title: Is there a way to merge these two simple queries
body: <p>I'm sure I'm ridiculous for thinking it's possible but is there a way to merge these two queries?</p>
  
  <p><strong>Query #1:</strong></p>
  
  <pre><code>select distinct 
      count(l.lease_id) as 'Count_Transactions_ALL', 
      sum(l.net_area) as 'Total_Area_ALL'
  from
      lease_deal.lease l
  where
      l.deal_approved_date &gt;= @dateFrom   
      and l.deal_approved_date  &lt;= @dateTo
      and l.lease_status in(@leaseStatus)
  </code></pre>
  
  <p><strong>Query #2:</strong></p>
  
  <pre><code>select distinct 
      count(l.lease_id) as 'Count_Transactions_NEW', 
  from
      lease_deal.lease l
  where
      l.deal_approved_date &gt;= @dateFrom   
      and l.deal_approved_date  &lt;= @dateTo
      and l.lease_status in(@leaseStatus)
      and l.negotiation_type = 'NEW'
  </code></pre>
  
  <p>My desired output would be:</p>
  
  <p>Count_Transactions_ALL, Total_Area_All, Count_Transactions_NEW</p>
  
  <p>x, y, z</p>