谦虚的比尔在炒股

分类

/ 注册

TA的专栏 0篇文章 0人订阅

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共88篇）

题解 | 浙江大学用户题目回答情况

select a.device_id, question_id, result from user_profile a inner join question_practice_detail b on a.device_id = b.device_id whe...

2025-05-09

0 44

题解 | 分组排序练习题

select university,avg(question_cnt) avg_question_cnt from user_profile group by university order by avg_question_cnt

2025-05-09

0 43

题解 | 分组过滤练习题

# 使用子查询,运行时间35ms占用内存6664KB # select * # from # ( # select # university, # avg(question_cnt) avg_question_cnt, # ...

2025-05-09

0 56

题解 | 分组计算练习题

select gender,university,count(university) user_num,avg(active_days_within_30) avg_active_day,avg(question_cnt) avg_question_cnt from user_profile gro...

2025-05-09

0 63

题解 | 计算男生人数以及平均GPA

select count(*) male_num,avg(gpa) avg_gpa from user_profile where gender = 'male'

2025-05-09

0 52

题解 | 查找GPA最高值

select max(gpa) gpa from user_profile where university = '复旦大学';

2025-05-09

0 44

题解 | 查看学校名称中含北京的用户

select device_id,age,university from user_profile where university like '%北京%'

2025-05-09

0 44

题解 | 操作符混合运用

select device_id,gender,age,university,gpa from user_profile where (gpa > 3.5 and university = '山东大学' ) or (gpa > 3.8 and university = '复旦大学') ...

2025-05-09

0 39