谦虚的比尔在炒股

分类

/ 注册

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

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共81篇）

题解 | 获取指定客户每月的消费额

select concat('2023-',every_month) time, sum(t_amount) total from ( select substr(t.t_time,6,2) every_month, t.t_a...

2025-05-27

0 31

题解 | 分析客户逾期情况

select pay_ability, concat(round(count(overdue_days) / count(*) * 100,1),'%') overdue_ratio from loan_tb as lt left join ...

2025-05-27

0 34

题解 | 最长连续登录天数

select user_id, max(cnt) max_consec_days from ( select user_id, sub_fdate, count(*) cnt from ( ...

2025-05-27

0 32

题解 | 每个月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 22

题解 | 基本数学函数

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

2025-05-20

0 26

题解 | 计算每日累计利润

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

2025-05-20

1 34

题解 | 电话号码格式校验

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 21

题解 | 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 21

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

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 28

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

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

2025-05-17

0 30