title: Select data from last month sql
body: <p>I have this code to select from my database data from current month:</p>
  
  <pre><code>SELECT * FROM daily_reports
  WHERE username = '$username' and MONTH(date) = MONTH(Now())
  order by date DESC
  </code></pre>
  
  <p>And now i want to display data from last month.</p>
  
  <p>column date is type date</p>