insert into score(id,name,sex,class,chinese,math,english)
values(1,'Peter','boy',1,75,85,69);
insert into score(id,name,sex,class,chinese,math,english)
values(2,'Ken','boy',1,55,56,89);
insert into score(id,name,sex,class,chinese,math,english)
values(3,'Anne','girl',2,66,85,69);
insert into score(id,name,sex,class,chinese,math,english)
values(4,'Sue','girl',2,62,77,88);
insert into score(id,name,sex,class,chinese,math,english)
values(5,'June','girl',1,55,66,88);
uj5u.com熱心網友回復：
不好意思，解決了
select class,
sum(case sex when 'boy' then 1 else 0 end) as boy_total,
sum(case sex when 'girl' then 1 else 0 end) as girl_total,
sum(chinese) as chinese_total,
sum(math) as math_total,
sum(english) as english_total from score group by class;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/118992.html
標籤：應用實例
上一篇：tensorflow2.0怎么讀取TERecords檔案
下一篇：小白Navicat破解受阻 求助