title: SQL query with week days
body: <p>I would like to know what is the best way of creating a report that will be grouped by the last 7 days - but not every day i have data. for example:</p>
  
  <p>08/01/10 | 0
  08/02/10 | 5
  08/03/10 | 6
  08/04/10 | 10
  08/05/10 | 0
  08/06/10 | 11
  08/07/10 | 1</p>
  
  <p>is the only option is to create a dummy table with those days and join them altogether?</p>
  
  <p>thank you</p>