Query: hackernews_jobs_by_days

select
  to_char(time::timestamptz, 'YYYY-MM-DD') as day,
  count(*)
from
  hackernews_job
where
  time::timestamptz > now() - interval '10 day'
group by
  day
order by
  day;