小宇啊

分类

/ 注册

全部文章（共111篇）

题解 | 商品价格排名

select t.product_id, t.product_name, t.type, t.price from (select product_id, price, type, product...

2025-06-12

0 60

题解 | 用户购买次数前三

select a.uid, a.cnt from (select t.uid, t.cnt, row_number() over(order by t.cnt desc) as rk from (select uid, ...

2025-06-12

0 49

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

with pro_employee as (select exam_id, avg(score) as avg_score, avg(timestampdiff(minute,start_time,submit_time)) as avg_minute from e...

2025-06-09

0 24

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

select a.log_day, a.user_id, b.hobby from (select user_id, date_format(log_time,'%Y-%m-%d') as log_day, rank()...

2025-05-23

0 51

题解 | 统计加班员工占比

select b.department, concat(round(sum(if(timestampdiff(second,a.first_clockin,a.last_clockin)/3600 >9.5,1,0)) / count(distinct a.staff...

2025-05-22

0 41

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

select b.department, round(avg(c.normal_salary - c.dock_salary),3) as avg_salary from (select staff_id, round(avg(normal_s...

2025-05-22

0 62

题解 | 查询订单

select a.order_id, c.customer_name, a.order_date from orders a inner join (select customer_id, max(order_date) as...

2025-05-22

0 59

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

select a.user_id, b.point + a.point as point from (select user_id, sum(order_price) as point from order_tb ...

2025-05-22

0 45

题解 | 每月及截止当月的答题情况

with mau_tb as (select date_format(start_time,'%Y%m') as start_month, count(distinct uid) as mau from exam_record group by 1), mon...

2025-05-13

0 50

题解 | 注册当天就完成了试卷的名单第三页

select er.uid, ui.level, ui.register_time, max(er.score) as max_score from exam_record er left join user_info ui on er.uid = ...

2025-04-27

0 36