Any clever SQL people out there? Given the raw data on the left, (a table of test results) how do I write a SQL query to give me the results on the right, (the results grouped by date as well as grouped by result)?
Update: a week later and traffic has fallen off of Cloudflare. Interestingly I don't see a corresponding increase on the origin server's bandwidth usage, but I do see more requests in the access log.