纯真的茶叶蛋拥抱太阳

分类

/ 注册

全部文章（共10篇）

题解 | 被重复观看次数最多的3个视频

select t.cid, t.pv, row_number() over(order by t.pv desc, c.release_date desc) as rk from ( select cid, uid, sum(count(*)) over(partition by cid) ...

2025-08-21

0 19

题解 | 网易云音乐推荐(网易校招笔试真题)

with t as(select distinct music_id from music_likes mk where user_id in (select follower_id from follow where user_id = 1) and music_id not in (select...

2025-08-20

0 28

题解 | 每天登陆最早的用户的内容喜好

with t as(select date(l.log_time) as log_day, user_id, u.hobby, rank() over(partition by date(l.log_time) order by l.log_time) as rk from login_tb l j...

2025-08-19

0 24

题解 | 统计加班员工占比

select s.department, concat(round(avg(if(timestampdiff(minute, a.first_clockin, a.last_clockin)/60 > 9.5, 1, 0))*100, 1), "%") as ratio f...

2025-08-19

0 14

题解 | 查询单日多次下订单的用户信息？

select date(o.order_time) as order_date, o.user_id, count(o.order_price) as order_nums, u.vip from order_tb o join uservip_tb u using(user_id) group b...

2025-08-19

0 25

题解 | 统计用户从访问到下单的转化率

select date(v.visit_time) as date, concat(round(((count(distinct o.user_id)/count(distinct v.user_id)))*100,1),"%") as cr from visit_tb v le...

2025-08-19

0 17

题解 | 查询培训指定课程的员工信息

select c.staff_id, s.staff_name from cultivate_tb c left join staff_tb s using(staff_id) where course like "%course3"

2025-08-17

0 27

题解 | 统计所有课程参加培训人次

select sum(length(course) - length(replace(course,",","")) + 1) as staff_nums from cultivate_tb where course is not null

2025-08-17

0 25

题解 | 查询连续入住多晚的客户信息？

select c.user_id, c.room_id, g.room_type, datediff(checkout_time, checkin_time) as days from checkin_tb c join guestroom_tb g using(room_id) where che...

2025-08-16

0 29

题解 | 分析客户逾期情况

select pay_ability, concat(format(avg(if(overdue_days is null, 0, 1)) * 100, 1),"%") as overdue_ratio from loan_tb join customer_tb using(cu...

2025-08-16

0 31