谦虚的比尔在炒股

分类

/ 注册

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

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共88篇）

题解 | 每个月Top3的周杰伦歌曲

select * from ( select fdate_month as month, row_number() over(partition by fdate_month order by count(song_name) desc,song_id asc) rankin...

2025-05-23

0 36

题解 | 基本数学函数

select *, abs(value) absolute_value, ceil(value) ceiling_value, floor(value) floor_value, round(value,1) rounded_value...

2025-05-20

1 39

题解 | 计算每日累计利润

select *, sum(profit) over(order by profit_date) cumulative_profit from daily_profits

2025-05-20

1 61

题解 | 电话号码格式校验

select * from contacts where phone_number regexp'^[1-9][0-9]{9}$' or phone_number regexp'[1-9]{3}-[0-9]{3}-[0-9]{4}' order by id asc

2025-05-20

0 37

题解 | 21年8月份练题总数

select count(distinct device_id) did_cnt, count(question_id) question_cnt from question_practice_detail where question_id is not null and month(da...

2025-05-20

0 33

题解 | 浙大不同难度题目的正确率

select difficult_level, sum(if(qpd.result = 'right',1,0))/count(result) correct_rate from user_profile as up inner join question_practice_detail as qp...

2025-05-17

0 54

题解 | 统计复旦用户8月练题情况

# select # up.device_id, # up.university, # count(*) question_cnt, # count(if(result = 'right', 1, null)) right_question_cnt # from # ...

2025-05-17

0 44

题解 | 找出每个学校GPA最低的同学

select up.device_id,up.university,up.gpa from user_profile up inner join ( select university,min(gpa) min_gpa from user_profile group by u...

2025-05-16

0 46

题解 | 截取出年龄

select profile_age age,count(*) number from ( select substr(profile,12,2) profile_age from user_submit )a group by profile_age

2025-05-16

0 53

题解 | 提取博客URL中的用户名

select device_id,substr(blog_url,11) user_name from user_submit

2025-05-16

0 60