电商数据分析师面试题分享

(1)select count(distinct name)from Table1;(2)select name,sum(score) as "总分"from Table1group by nameorder by sum(score) desc;(3)select name from Table1group by name having min(score) < 60;(4)select name from Table1group by name having min(score) > 60;(5)select name,sum(score) as "总分"from (select * from Table1unionselect * from Table2)temp group by name;(6)-- 所有课程超过60分的学生以及他们对应的总分select name,sum(score) as "总分"from (select * from Table1unionselect * from Table2)temp group by namehaving min(score) > 60;