select year as 年,
SUM(case when time='A' then data else 0 end) as A班级,
SUM(case when time='B' then data else 0 end) as B班级,
SUM(case when time='C' then data else 0 end) as C班级
FROM sales group by year
select year as 年,
SUM(case when time='A' then data else 0 end) as A班级,
SUM(case when time='B' then data else 0 end) as B班级,
SUM(case when time='C' then data else 0 end) as C班级
FROM sales group by year