title: Using SELECT UNION and returning output of two columns from one table
body: <p>I am creating a query that counts the amount of male and female actors in my table. My current statement is as such:</p>
  
  <pre><code>Select COUNT(ActorGender) “Male Actors” 
  from (tblActor ta WHERE ta.ActorGender in(‘m’)
  UNION
  Select COUNT(ActorGender) “Female Actors” 
  from tblActor ta 
  WHERE ta.ActorGender in(‘f’);
  </code></pre>
  
  <p>The output ends up being:</p>
  
  <pre><code>Male Actors
  -----------
            7
           21
  </code></pre>
  
  <p>I want the output to look like:</p>
  
  <pre><code>Male Actors   Female Actors
  -----------   -------------
            7              21
  </code></pre>
  
  <p>I am looking for an alternative to go about this <strong>without using the CASE WHEN or THEN clauses</strong>.</p>
  
  <p>Thanks in advance for the help as usual. </p>