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

(1)select count(distinct name)from Table1;(2)selectname,sum(score) as "总分"from Table1group by nameorder by sum(score) desc;(3)select namefrom Table1group by namehaving min(score) < 60;(4)select nam

南湖渔歌

1203人浏览 · 2021-04-21 16:40:06

南湖渔歌 · 2021-04-21 16:40:06 发布

在这里插入图片描述

(1)

select count(distinct name)
from Table1;

(2)
select  name
       ,sum(score) as "总分"
from Table1
group by name
order by sum(score) desc;

(3)
select name 
from Table1
group by name 
having min(score) < 60;

(4)

select name 
from Table1
group by name 
having min(score) > 60;

(5)

select  name
       ,sum(score) as "总分"
from 
(select * 
 from Table1
 union
 select * 
 from Table2
)temp 
group by name;

(6)

-- 所有课程超过60分的学生以及他们对应的总分

select  name
       ,sum(score) as "总分"
from 
(select * 
 from Table1
 union
 select * 
 from Table2
)temp 
group by name
having min(score) > 60;