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

南湖渔歌

于 2021-04-21 16:40:06 发布

阅读量1.2k

点赞数

分类专栏：编程工具

本文链接：https://blog.csdn.net/weixin_44976611/article/details/115962565

版权

编程工具专栏收录该内容

4 篇文章

订阅专栏

在这里插入图片描述

(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;