Query: Requests by Status Code

select
  case
    when status between 200 and 299 then '2xx Success'
    when status between 300 and 399 then '3xx Redirect'
    when status between 400 and 499 then '4xx Client Error'
    when status between 500 and 599 then '5xx Server Error'
    else 'Other'
  end as "Status Category",
  count(*) as "Request Count"
from
  apache_access_log
where
  status is not null
group by
  "Status Category"
order by
  "Status Category";