title: Combining select statements with dates
body: <p>Please help me, I want my SQL Select statement combined in one query</p>
  
  <pre><code>&lt;?php
  
  Total Assigned = SELECT date(DATE_DISTRIBUTE)
       , COUNT(DATE_DISTRIBUTE) AS TotalAssigned
    FROM ata_report_extracted WHERE STATUS ='DISTRIBUTED'
   GROUP BY date(DATE_DISTRIBUTE) ";
  
  
  Total Handled = "SELECT date(DATE_HANDLED)
       , COUNT(DATE_HANDLED) AS TotalHandled
    FROM ata_report_extracted WHERE PROS_DESCRIPTION NOT IN ('Open', 'Acknowledged', 'Fallout', 'Cleared') AND STATUS ='DISTRIBUTED'
   GROUP BY date(DATE_HANDLED) ";
  
  Total Resolved ="SELECT date(DATE_HANDLED)
       , COUNT(DATE_HANDLED) AS TotalResolved
    FROM ata_report_extracted WHERE PROS_DESCRIPTION = 'Closed' AND STATUS ='DISTRIBUTED'
   GROUP BY date(DATE_HANDLED) ";
  
  TotalDispatch ="SELECT date(DATE_HANDLED)
       , COUNT(DATE_HANDLED) AS TotalDispatch
    FROM ata_report_extracted WHERE PROS_DESCRIPTION ='Dispatch' AND STATUS ='DISTRIBUTED'
   GROUP BY date(DATE_HANDLED) ";
  
  
  TotalPending ="SELECT date(DATE_HANDLED)
       , COUNT(DATE_HANDLED) AS TotalPending
    FROM ata_report_extracted WHERE PROS_DESCRIPTION IN ('TOKUNDEROB', 'CALLNOANSWER') AND STATUS ='DISTRIBUTED'
   GROUP BY date(DATE_HANDLED) ";
  
   ?&gt;
  
  
  &lt;?php
  
  Total Assigned = SELECT date(DATE_DISTRIBUTE)
       , COUNT(DATE_DISTRIBUTE) AS TotalAssigned
    FROM ata_report_extracted WHERE STATUS ='DISTRIBUTED'
   GROUP BY date(DATE_DISTRIBUTE) ";
  
  
  Total Handled = "SELECT date(DATE_HANDLED)
       , COUNT(DATE_HANDLED) AS TotalHandled
    FROM ata_report_extracted WHERE PROS_DESCRIPTION NOT IN ('Open', 'Acknowledged', 'Fallout', 'Cleared') AND STATUS ='DISTRIBUTED'
   GROUP BY date(DATE_HANDLED) ";
  
  Total Resolved ="SELECT date(DATE_HANDLED)
       , COUNT(DATE_HANDLED) AS TotalResolved
    FROM ata_report_extracted WHERE PROS_DESCRIPTION = 'Closed' AND STATUS ='DISTRIBUTED'
   GROUP BY date(DATE_HANDLED) ";
  
  TotalDispatch ="SELECT date(DATE_HANDLED)
       , COUNT(DATE_HANDLED) AS TotalDispatch
    FROM ata_report_extracted WHERE PROS_DESCRIPTION ='Dispatch' AND STATUS ='DISTRIBUTED'
   GROUP BY date(DATE_HANDLED) ";
  
  
  TotalPending ="SELECT date(DATE_HANDLED)
       , COUNT(DATE_HANDLED) AS TotalPending
    FROM ata_report_extracted WHERE PROS_DESCRIPTION IN ('TOKUNDEROB', 'CALLNOANSWER') AND STATUS ='DISTRIBUTED'
   GROUP BY date(DATE_HANDLED) ";
  
   ?&gt;
  </code></pre>
  
  <p>Display total reports daily in one query</p>