Count Google Open DNS Queries

This query counts how many DNS queries come from Google's Open DNS resolvers.

select day, count(1) as tot
from dns.queries
where year=2017 and month=8 and is_google
group by day
order by tot desc

1 112407798
2 81018873
3 83004014
4 85193345
5 71789462
...