Events per day

query.sql

/* events per day */
SELECT 
    DATE(timestamp / 10000000 - 62135596800, 'unixepoch') as date, 
    (CASE 
        WHEN strftime('%w', DATE(timestamp / 10000000 - 62135596800, 'unixepoch')) == '0' THEN 'Sunday'
        WHEN strftime('%w', DATE(timestamp / 10000000 - 62135596800, 'unixepoch')) == '1' THEN 'Monday'
        WHEN strftime('%w', DATE(timestamp / 10000000 - 62135596800, 'unixepoch')) == '2' THEN 'Tuesday'
        WHEN strftime('%w', DATE(timestamp / 10000000 - 62135596800, 'unixepoch')) == '3' THEN 'Wednesday'
        WHEN strftime('%w', DATE(timestamp / 10000000 - 62135596800, 'unixepoch')) == '4' THEN 'Thursday'
        WHEN strftime('%w', DATE(timestamp / 10000000 - 62135596800, 'unixepoch')) == '5' THEN 'Friday'
        WHEN strftime('%w', DATE(timestamp / 10000000 - 62135596800, 'unixepoch')) == '6' THEN 'Saturday'
     END) as 'day of the week', 
    count(*) as 'count of events'
from events 
group by date 
order by date desc