title: SQL Group By - Return results as Single Row instead of Multiple (Flatten results)
body: <p>I have the following job table:</p>
  
  <pre><code>job_id | is_full_time | is_short_term 
       1 |      0       |      0
       2 |      0       |      1
       3 |      1       |      0
       4 |      1       |      1
  </code></pre>
  
  <p>I have the following query and I'm getting results in 4 rows.</p>
  
  <pre><code>SELECT is_full_time, is_short_term, 
  COUNT(CASE WHEN is_full_time = 1 AND is_short_term = 0 THEN 1 ELSE NULL END) AS FT_Long, 
  COUNT(CASE WHEN is_full_time = 1 AND is_short_term = 1 THEN 1 ELSE NULL END) AS FT_Short,
  COUNT(CASE WHEN is_full_time = 0 AND is_short_term = 0 THEN 1 ELSE NULL END) AS PT_Long, 
  COUNT(CASE WHEN is_full_time = 0 AND is_short_term = 1 THEN 1 ELSE NULL END) AS PT_Short
  FROM job
  GROUP by is_full_time, is_short_term
  </code></pre>
  
  <p>My results look like this:</p>
  
  <pre><code>FT_Long | FT_Short | PT_Long | PT_Short
      1   0     0     0
      0   1     0     0
      0   0     1     0
      0   0     0     1
  </code></pre>
  
  <p>How can I combine this result into a single result row?</p>
  
  <p>I want to see this: </p>
  
  <pre><code> FT_Long | FT_Short | PT_Long | PT_Short
          1   1     1     1
  </code></pre>