Please refer to a previous question I posted about counts per month.
I would like to do the same thing but count for each day of current month, and if there is a zero count, i would like that to show as well.
Here was the query the was worked out for count of month.
SELECT TO_CHAR(m, 'mm yyyy') AS themonth, COUNT(q.quote_id) AS numoflosses
FROM q_quotes q
( SELECT TO_DATE('2009' || TO_CHAR(LEVEL, 'fm09'), 'yyyymm') m
CONNECT BY LEVEL <= 12)
ON q.quote_status_id IN (8, 10, 13)
AND q.quote_dt >= m
AND q.quote_dt < ADD_MONTHS(m, 1)
AND q.quote_id NOT IN ( SELECT linked_quote_id FROM q_quote_links)
GROUP BY m
ORDER BY m ASC;