title: Getting the difference of a count on 2 queries in mysql
body: <p>I am totally new to SQL and have managed to get 2 queries to show me the count.</p>
  
  <pre><code>SELECT COUNT(*) AS 'Sold' FROM table_1 WHERE date_sold &gt;= CURRENT_DATE
  </code></pre>
  
  <p>and the same from table_1 but for date_purchased</p>
  
  <p>Now I need to have a single query, using the 2 queries I have already, to show the difference between purchased today and sold today.</p>
  
  <p>So like this...</p>
  
  <p><a href="https://i.stack.imgur.com/BwcUo.png" rel="nofollow noreferrer">Data</a></p>
  
  <p>So I need a query to give me the difference in the 2 counts</p>
  
  <p>Hope that makes sense. </p>
  
  <p>Thanks in advance.</p>