L重启中

分类

/ 注册

全部文章（共51篇）

题解 | 商品交易(网易校招笔试真题)

with t2 as ( select goods_id ,sum(count) total from trans group by 1 ) select id ,name ,weight ,total from goods t1 join t2 on t1.id = t2.go...

2026-03-15

0 10

题解 | 商品交易(网易校招笔试真题)

with t2 as ( select goods_id ,sum(count) total from trans group by 1 ) select id ,name ,weight ,total from goods t1 join t2 on t1.id = t2.go...

2026-03-15

0 14

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

select t1.department department ,round(avg(t2.normal_salary - t2.dock_salary),3) avg_salary from staff_tb t1 join salary_tb t2 on t1.staff_id = t2.st...

2026-03-15

0 27

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

select date_format(order_time,'%Y-%m-%d') order_date ,t1.user_id ,count(t1.user_id) order_nums ,t2.vip vip from order_tb t1 join uservip_tb t2 on t1...

2026-03-14

0 16

题解 | 统计用户获得积分

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

2026-03-14

0 18

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

select t1.staff_id ,t2.staff_name ,concat(round((t1.dock_salary/t1.normal_salary)*100,1),'%') dock_ratio from salary_tb t1 join staff_tb t2 on t1.sta...

2026-03-14

0 18

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

select t2.vip ,if(sum(t1.order_price)>0,sum(t1.order_price),0) order_total from order_tb t1 right join uservip_tb t2 on t1.user_id = t2.user_id g...

2026-03-14

0 17

题解 | 统计商家不同会员每日访问人次及访问人数

select t2.vip ,count(t1.user_id) visit_nums ,count(distinct t1.user_id) visit_users from visit_tb t1 join uservip_tb t2 on t1.user_id = t2.user_id gr...

2026-03-14

0 17

题解 | 统计各岗位员工平均工作时长

select post ,round(avg(个人时长),3) work_hours from ( select t1.post ,t1.staff_id ,timestampdiff(second,t2.first_clockin,t2.last_clockin)/3600 个人时长 ...

2026-03-14

0 22

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

select t1.staff_id ,t2.staff_name from cultivate_tb t1 join staff_tb t2 on t1.staff_id = t2.staff_id where t1.course like '%course3%'

2026-03-14

0 11