最爱青草蛋糕

分类

/ 注册

全部文章（共74篇）

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

select cid,pv, row_number()over(order by pv desc,release_date desc) as rk from ( select c.cid as cid,release_date,pv from course_info_tb as c join ( s...

2025-08-12

0 32

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

select music_name from ( select id,t7.music_name as music_name from (select t6.music_name as music_name from (select music_name from ( select music_id...

2025-08-08

0 33

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

select log_day,u.user_id,hobby from user_action_tb as u join (select user_id,log_day, rank()over(partition by log_day order by log_time) as rank_n fro...

2025-08-08

0 22

题解 | 统计加班员工占比

select department,concat(round(sum(count_newma)/sum(count_1)*100,1),'%') as ratio from ( select s.staff_id,department,newma,1 as count_1, case when ne...

2025-08-07

0 29

题解 | 统计各个部门平均薪资

select department,round(avg(salary),3) as avg_salary from ( select st.staff_id,department,salary from staff_tb as st join ( select staff_id, normal_sa...

2025-08-07

0 27

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

select order_date,u.user_id,number as order_nums,vip from uservip_tb as u join ( select user_id, date(order_time) as order_date,count(1) as number fro...

2025-08-07

0 26

题解 | 更新用户积分信息？

select u.user_id,point+price as point from uservip_tb as u join (select user_id, sum(order_price) as price from order_tb where order_price > 100 gr...

2025-08-06

0 21

题解 | 统计用户获得积分

select user_id,sum(floor(timestampdiff(minute,visit_time,leave_time)/10)) as point from visit_tb group by user_id order by point desc

2025-08-06

0 16

题解 | 统计员工薪资扣除比例

select staff_id,staff_name,dock_ratio from ( select st.staff_id as staff_id,staff_name,department,concat(round(dock_salary/normal_salary*100,1),'%') a...

2025-08-06

0 30

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

select o_time as date, concat(round(order_num/visit_num*100,1),'%') as cr from ( select o_time,count(o_time) as order_num from ( select user_id,date(o...

2025-08-05

0 28