title: MySQL rearrange query structure
body: <p>I'm trying to display a chart based on a query I built in dbForge Studio but its not charting correctly because I think its only selecting 1 axis of data.  </p>
  
  <p>The query is displaying the result like so:</p>
  
  <pre><code>column1  column2  column3
  data      data     data
  </code></pre>
  
  <p>I guess to properly display the chart, I would need it in a format like this:</p>
  
  <pre><code>Type      Total
  column1    data
  column2    data
  column3    data
  </code></pre>
  
  <p>Here is the query below. How do I add in the virtual columns like so and rearrange this?</p>
  
  <pre><code>    SELECT 
        (SELECT COUNT(T1.APP_UID)
         FROM TABLE1 T1 
         WHERE T1.APP_STATUS = 'To_Do' ) AS 'Column1' ,
  
        (SELECT COUNT(T1.APP_UID)
         FROM TABLE1 T1 
         WHERE T1.APP_STATUS = 'Completed' ) AS 'Column2' ,
  
        (SELECT COUNT(T1.APP_UID)
         FROM TABLE1 T1 ) AS 'Column3'
  </code></pre>