原表如下：
Name Type Level
A-1 A 1
A-2 A 2
C-1 C 1
C-2 C 2
A-3 A 1
C-3 C 2
怎么样能查询出下面的表呢？
Name Level_1 Level_2
A 2 1
C 1 2
------解决方案--------------------------------------------------------
- SQL code
select type, sum(if(level=1,1,0)) as level_1, sum(if(level=2,1,0)) as level_2from yourTablegruop by type