Get views and subscribes for a window pool

select toDate(timestamp) as date, window_id, sum(view_count) as views, sum(subscribe_count) as subscribes from window_events where window_pool_id = 123 group by date