呼吸丶zero

分类

/ 注册

全部文章（共18篇）

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

select staff_id ,staff_name ,concat(round(dock_salary/normal_salary*100,1),'%') as dock_ratio from staff_tb join salary_tb using(staff_id) where depar...

2025-07-09

0 13

题解 | 查询下订单用户访问次数？

with t as ( select distinct user_id from order_tb where date(order_time) = '2022-9-2' ...

2025-07-09

0 10

题解 | 统计各等级会员用户下订单总额

select vip , sum(case when order_price is null then 0 else order_price end) as order_total from order_tb right join uservip_tb using(user_id) group by...

2025-07-09

0 15

题解 | 查询连续登陆的用户

select user_id from ( select user_id, if(lead(log_date) over (PARTITION BY user_id ORDER BY log_date) - lo...

2025-07-08

1 15

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

select staff_id ,staff_name from staff_tb join cultivate_tb using(staff_id) where course like '%course3%'

2025-07-07

0 21

题解 | 统计每个产品的销售情况

with t1 as ( select product_id, customer_age_group from ( select ...

2025-07-06

0 15

题解 | 完成员工考核试卷突出的非领导员工

with t as ( select tag, avg(score) as avs, avg(timestampdiff(second, start_time, submit_time)) as exam...

2025-07-06

0 18

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

SELECT m.music_name FROM music m WHERE EXISTS ( SELECT 1 FROM follow f JOIN music_likes ml ON f.follower_id = ml.user_id WHERE f.user_...

2025-07-06

0 14