title: Multiple sum in SQL query
body: <pre><code>SELECT sum( plot_status = 'OPEN' ) AS OPEN 
       , sum( plot_status = 'SOLD' ) AS SOLD
  FROM `tbl_plot`
  GROUP BY `plot_status
  </code></pre>
  
  <p>This is giving</p>
  
  <pre><code>OPEN   SOLD
  7       0
  0       8
  </code></pre>
  
  <p>How to make it</p>
  
  <pre><code>OPEN  SOLD
  7      8
  </code></pre>
  
  <p>Or is it possible?</p>