title: Create New Columns from Row Values then Group By
body: <p>My current table looks like this:</p>
  <pre><code>+-------+------+
  | Level | Team |
  +-------+------+
  |     1 |    1 |
  |     2 |    1 |
  |     2 |    1 |
  |     3 |    2 |
  |     3 |    2 |
  |     3 |    2 |
  +-------+------+
  </code></pre>
  <p>I want to group by level and know the count of level for both teams. I can easily get the count of a single team by using the following:</p>
  <pre><code>SELECT Level, Count(Team)
  FROM table
  WHERE Team = 1
  GROUP BY Level
  SORT BY Level;
  +-------+-------------+
  | Level | Team1_Count |
  +-------+-------------+
  |     1 |           1 |
  |     2 |           2 |
  |     3 |           0 |
  +-------+-------------+
  </code></pre>
  <p>However, the end result I want is below:</p>
  <pre><code>+-------+-------------+-------------+
  | Level | Team1_Count | Team2_Count |
  +-------+-------------+-------------+
  |     1 |           1 |           0 |
  |     2 |           2 |           0 |
  |     3 |           0 |           3 |
  +-------+-------------+-------------+
  </code></pre>
  <p>Removing the WHERE clause gives the total per Level but does not split it into Teams. How do I make it so both of these new columns are created and show the counts per Level?</p>