select * from wyc_test
select a.date,
sum(case a.name when '小说' then a.scount else 0 end) 'sum_小说',
max(case a.name when '小说' then a.scount else 0 end) 'max_小说',
sum(case a.name when '微信' then a.scount else 0 end) '微信',
max(case a.name when '小说' then a.scount else 0 end) 'max_微信'
from wyc_test a
group by date;
select * from STSCORE;
select a.classno,
max(case a.course when 'Chemistry' then a.grade1 else 0 end) 'Chemistry',
max(case a.course when 'English' then a.grade1 else 0 end) 'English',
max(case a.course when 'Math' then a.grade1 else 0 end) 'Math',
max(case a.course when 'French' then a.grade1 else 0 end) 'French',
max(case a.course when 'Physics' then a.grade1 else 0 end) 'Physics'
from
( select classno,course,avg(grade) as grade1 from stscore
group by course,classno
order by course ) a
group by classno;