mysql - How to show all days regardless of activity -

I have two tables - quotes and bookings

I used to show the date of "quotation date" Choosing the week but if booking is done without a quotation, then there is no "quotation date" and therefore this row is never displayed.

How can I create a column that only occurs every day for the last 30, 60 or 90 days, shows the number of quotes and number of bookings for that day?

Existing SQL using quotation marks:

  Select Cast (Q is secured as date) AS coat date, count (q.id) AS Quotes, B. quote_id = q.id WHERE year (q.created) = '2010' and month (q.created) = '0' from quoting marks by AS Quotes, count (B.Coight_ID) from AS Booking, QLFT Opener Booking B Cast by group (created as date) Order by order (queue has been created as date) DESC  

This will not be the result on which days no quotes were made, display them ...