title: harcode Rows with union
body: <p>I have a select query  </p>
  
  <pre><code>SELECT
      COUNT(DISTINCT CASE WHEN LANGUAGE = 'CHINESE' THEN email_address END) AS CHINESE,
      COUNT(DISTINCT CASE WHEN LANGUAGE = 'FRENCH' THEN email_address END) AS FRENCH,
      COUNT(DISTINCT CASE WHEN LANGUAGE = 'PORTUGUESE' THEN email_address END) AS PORTUGUESE,
      COUNT(DISTINCT CASE WHEN LANGUAGE = 'SPANISH' THEN email_address END) AS SPANISH,
      COUNT(DISTINCT CASE WHEN LANGUAGE = 'KOREAN' THEN email_address END) AS KOREAN
  FROM 
      table1;
  </code></pre>
  
  <p>The result is</p>
  
  <pre><code>CHINESE PORTUGUESE KOREAN SPANISH FRENCH  
    2  22 3 4 5 
  </code></pre>
  
  <p>Now I want to add another row with hardcoded values</p>
  
  <pre><code>select 
  COUNT(DISTINCT CASE WHEN LANGUAGE = 'CHINESE' THEN email_address END) AS CHINESE,
  COUNT(DISTINCT CASE WHEN LANGUAGE = 'FRENCH' THEN email_address END) AS FRENCH,
  COUNT(DISTINCT CASE WHEN LANGUAGE = 'PORTUGUESE' THEN email_address END) AS PORTUGUESE,
  COUNT(DISTINCT CASE WHEN LANGUAGE = 'SPANISH' THEN email_address END) AS SPANISH,
  COUNT(DISTINCT CASE WHEN LANGUAGE = 'KOREAN' THEN email_address END) AS KOREAN
  FROM table1;
  UNION
  SELECT 30,40,50,60,70 from table 2;
  </code></pre>
  
  <p>It is not yielding results</p>
  
  <p>I want the result like   </p>
  
  <pre><code>CHINESE PORTUGUESE KOREAN SPANISH FRENCH  
  row_1  2 2 1 1 1  
  row_2  30 305 290 0 0  ( hardcoded values)  
  </code></pre>