比较酷的查询

SELECT

sum(case WHEN C_PP='上海' THEN 1 ELSE 0 END) AS '上海',
sum(CASE C_PP WHEN '北京现代' THEN 1 ELSE 0 END) AS '北京现代',
sum(CASE C_PP WHEN '北京现代索娜塔' THEN 1 ELSE 0 END) AS '北京现代索娜塔',
sum(CASE C_PP WHEN '北京现代途胜' THEN 1 ELSE 0 END) AS '北京现代途胜',
count(C_PP) AS '其他'

FROM dbo.T_YC_CL