我当前的表如下所示：

+-------+------+
| Level | Team |
+-------+------+
|     1 |    1 |
|     2 |    1 |
|     2 |    1 |
|     3 |    2 |
|     3 |    2 |
|     3 |    2 |
+-------+------+

我想按级别分组，并知道两个团队的级别计数。我可以使用以下方法轻松计算单个团队的人数：

SELECT Level, Count(Team)
FROM table
WHERE Team = 1
GROUP BY Level
SORT BY Level;
+-------+-------------+
| Level | Team1_Count |
+-------+-------------+
|     1 |           1 |
|     2 |           2 |
|     3 |           0 |
+-------+-------------+

然而，我想要的最终结果如下：

+-------+-------------+-------------+
| Level | Team1_Count | Team2_Count |
+-------+-------------+-------------+
|     1 |           1 |           0 |
|     2 |           2 |           0 |
|     3 |           0 |           3 |
+-------+-------------+-------------+

删除where子句会给出每个级别的总数，但不会将其拆分为多个组。如何创建这两个新列并显示每个级别的计数？