title: how to show only since and until date data
body: <p>I have the next sql code </p>
  
  <pre><code>SELECT date,count(clics)
  FROM advertising_clics
  WHERE date &gt; CURDATE() - INTERVAL 7 DAY
  GROUP BY date
  </code></pre>
  
  <p>The Result is </p>
  
  <pre><code>date            count(clics)
  2015-08-29          4
  2015-08-30          1
  2015-08-31          1
  2015-09-01          1
  2015-09-02          1
  </code></pre>
  
  <p>but I want the result to be this</p>
  
  <pre><code>date            count(clics)
      2015-08-29          4
      2015-09-02          1
  </code></pre>