title: Multiple output with one SQL query
body: <p>I'm trying to write an SQL query that will output multiple variables depending on how many times a specific quantity exists in the DB. This information will then be used in a chart.</p>
  
  <p>The DB is set  as following:</p>
  
  <pre><code>ID | quantity | etc..
  ---------------------
  1  |   2      |
  2  |   6      |
  3  |   1      |
  4  |   2      |
  .
  .
  .
  </code></pre>
  
  <p>Here is the query I made:</p>
  
  <pre><code>SELECT 
    COUNT(CASE WHEN quantity = 1) AS quantity1, 
    COUNT(CASE WHEN quantity = 2) AS quantity2
  FROM orders
  </code></pre>
  
  <p>But I want it to output like this:</p>
  
  <pre><code>quantity1 | quantity2
  ---------------------
      1     |   2      |
  </code></pre>
  
  <p>Instead I am getting these error messages:<br><br>
  <img src="https://i.stack.imgur.com/D0Uxa.png" alt="enter image description here"></p>
  
  <p>Thanks in advance!</p>
  
  <p>EDIT: If you want to test your code on my database, the link is below...</p>
  
  <p>-Link Removed-</p>