title: Rotate results with SQL
body: <p>I'm using <a href="https://github.com/ankane/blazer" rel="nofollow noreferrer">Blazer</a> have the following query:</p>
  
  <pre><code>SELECT 
  sum(active_paid_users_count) as Active,
  sum(inactive_paid_users_count) as Inactive,
  sum(free_users_count) as Free
  FROM accounts
  WHERE
    trialing = false
    AND
    cancelled = false
  </code></pre>
  
  <p>This produces the following table:</p>
  
  <p><a href="https://i.stack.imgur.com/aKjix.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aKjix.png" alt="sql results"></a></p>
  
  <p>I'd like to rotate this table so that I can get a pie chart result out of <a href="https://blazer.dokkuapp.com/queries/17-pie-chart" rel="nofollow noreferrer">Blazer</a>. It would end up looking like this:</p>
  
  <pre><code>Type     Count
  active      31
  inactive    76
  free       190
  </code></pre>