Count Google Open DNS Queries

Description:

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

Impala Query:

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

Example Output:

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