title: Redshift - Find day wise count for the past 7 days dynamically
body: <p>I am trying to build a query that would capture sales by day for the past 7 days.</p>
  
  <p>Given below is what I have built:</p>
  
  <pre><code>select name,sale_date,count(*)
  from daily_sales
  where sale_date between current_date and current_date - 7
  group by name,sale_date;
  </code></pre>
  
  <p>I keep getting zero records when I know there is data for this time range. Could anyone help find where I am going wrong with the above query.</p>