(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;
电商数据分析师面试题分享
最新推荐文章于 2024-04-17 22:15:15 发布