SQL事件名行变成列，次数列变行

SELECT IMSI
,callinsms_setup=SUM(CASE WHEN event_name='callinsms_setup' THEN 1 ELSE 0 END)
,idle_lup=SUM(CASE WHEN event_name='idle_lup' THEN 1 ELSE 0 END)
,idle_moc=SUM(CASE WHEN event_name='idle_moc' THEN 1 ELSE 0 END)
,idle_mosms=SUM(CASE WHEN event_name='idle_mosms' THEN 1 ELSE 0 END)
,idle_mtsms=SUM(CASE WHEN event_name='idle_mtsms' THEN 1 ELSE 0 END)
,idle_pagres=SUM(CASE WHEN event_name='idle_pagres' THEN 1 ELSE 0 END)
,idle_poweroff=SUM(CASE WHEN event_name='idle_poweroff' THEN 1 ELSE 0 END)
FROM #t_whole_call_union_otherevent_bookticket_090706
GROUP BY IMSI