Report question

Question: PostgreSQL query to count/group by day and display days with no data