SELECT
 COUNT(*) as count,
 CASE WHEN is_pageview = 1 THEN 'entity_page'
 ELSE
  CASE WHEN uri_path LIKE '/w/api.php%' THEN 'api'
  ELSE CASE WHEN uri_host = 'query.wikidata.org' AND uri_path LIKE '%/sparql' THEN 'wdqs'
       ELSE 'other'
       END
  END
 END AS request_category,
 CASE WHEN cache_status IN ('pass','miss') THEN 0 ELSE 1 END AS is_cached
FROM
  wmf.webrequest
WHERE
  uri_host IN ('www.wikidata.org', 'query.wikidata.org')
  AND (is_pageview = TRUE OR uri_path LIKE '/w/api.php%' OR uri_path LIKE '%/sparql')
  AND year = 2021
  AND month = 5
  AND day = 6
  AND hour = 8
GROUP BY
 (CASE WHEN is_pageview = 1 THEN 'entity_page'
 ELSE
  CASE WHEN uri_path LIKE '/w/api.php%' THEN 'api'
  ELSE CASE WHEN uri_host = 'query.wikidata.org' AND uri_path LIKE '%/sparql' THEN 'wdqs'
       ELSE 'other'
       END
  END
 END),
  (CASE WHEN cache_status IN ('pass','miss') THEN 0 ELSE 1 END)
ORDER BY request_category, is_cached
LIMIT 25;