SQL-行转列

1、现有一个表的信息，如下：

编写sql，如何显示如下信息：

sql语句：

select address,
SUM(CASE WHEN dengji = 'A' THEN 1 ELSE 0 END) AS 'A' , 
SUM(CASE WHEN dengji = 'B' THEN 1 ELSE 0 END) AS 'B' , 
SUM(CASE WHEN dengji = 'C' THEN 1 ELSE 0 END) AS 'C'  
from table
group by address