关于统计分析的问题

Question

目前表里数据有line          type             status
1               a                     001
1               a                    001
1               a                      002
2              b                      001
2               a                     002
3               c                     003想要统计成line        typr        001       002       003    
1               a             2          1           0        
2              b              1          0           0        
2               a             0           1           0        
3              c              0            0           1        这个SQL怎么写啊 谢谢

Answer 1

SELECT LINE,
       TYPE,
       SUM(CASE WHEN STATUS = '001' THEN 1 ELSE 0) "001",
       SUM(CASE WHEN STATUS = '002' THEN 1 ELSE 0) "002",
       SUM(CASE WHEN STATUS = '003' THEN 1 ELSE 0) "003"
  FROM TABLE1
 GROUP BY LINE, TYPE

Answer 2

decode函数