Last active
January 14, 2019 05:46
-
-
Save jamescridland/748c693507b136ddce586d86b1a1e9b1 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT count(*),useragent FROM cloudfront_logs | |
WHERE "date" BETWEEN DATE '2019-01-01' AND DATE '2019-01-31' | |
AND uri LIKE '/audio/%' AND bytes>750000 GROUP BY useragent ORDER BY useragent |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment