Queries per day for a domain name

Get # of queries per day for a domain name.
With this query you can count the number of daily queries over a period of time.

select trunc(query_ts,'DD') as qdate, count(1) as qtot
from dns.queries
where year = 2017 and month = 8
and domainname = "sidn.nl"
group by qdate
order by qdate asc

1 2017-08-01 00:00:00 495795
2 2017-08-02 00:00:00 481837
3 2017-08-03 00:00:00 474558
4 2017-08-04 00:00:00 471917
5 2017-08-05 00:00:00 433962
6 2017-08-06 00:00:00 420932