mysql 横向查询

效果：

select event_owner pointCode, 
sum(case WHEN event_code = 'A1PL' THEN total else 0 end ) as A1PL, 
sum(case WHEN event_code = 'A1ZD' THEN total else 0 end ) as A1ZD, 
sum(case WHEN event_code = 'A1JD' THEN total else 0 end ) as A1JD, 
sum(case WHEN event_code = 'A1XY' THEN total else 0 end ) as A1XY, 
sum(case WHEN event_code = 'A1FS' THEN total else 0 end ) as A1FS, 
sum(case WHEN event_code = 'A1YC' THEN total else 0 end ) as A1YC 
FROM 
(select event_owner,count(*) total ,event_code 
FROM 
(SELECT event_owner, event_code ,event_id 
FROM 
tb_event_timeline et WHERE event_code like 'A%' AND event_type in (1,2) group by event_id,event_owner,event_code) temp 
GROUP BY event_code,event_owner)_temp 
group by event_owner