title: how to convert row in column in sql
body: <p>i have table employee</p>
  
  <pre><code>+------+-----------+
  | name | is_active |
  +------+-----------+
  |  a   |         0 |
  |  b   |         1 |
  |  c   |         1 |
  |  d   |         1 |
  |  e   |         0 |
  +------+-----------+
  </code></pre>
  
  <p>when we use query</p>
  
  <pre><code>select   is_active, count(*) count 
  from     employee 
  group by is_active;
  </code></pre>
  
  <p>then output in form of</p>
  
  <pre><code>+-----------+--------+
  | is_active |  count |
  +-----------+--------+
  |         1 |      3 |
  |         0 |      2 |
  +-----------+--------+
  </code></pre>
  
  <p>but i want to output in that form</p>
  
  <pre><code>+-----------+---+----+
  | is_active | 0 |  1 |
  +-----------+---+----+
  | count     | 2 |  3 |
  +-----------+---+----+
  </code></pre>