牛客63343748号

分类

/ 注册

全部文章（共39篇）

题解 | 获取所有非manager员工当前的薪水情况

select dept.dept_no, salaries.emp_no, salaries.salary from salaries left join dept_emp as dept on dept.emp_no=salaries.emp_no where ...

2025-04-06

0 29

题解 | 更新员工信息表

with a as ( select * from EMPLOYEE_INFO union all select EMPLOYEE_ID,NEW_POSITION,UPDATE_DT from EMPLOYEE_UPDATE ) select c.EMPLOYEE_ID, c.P...

2025-04-05

1 35

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

with 源表 as ( select * from orders as c join products as b using (product_id) join ...

2025-03-19

0 41

题解 | 每个顾客最近一次下单的订单信息

select c.order_id, c.customer_name, c.order_date from ( select a.order_id, b. customer_name, a.order_date, row_n...

2025-03-19

2 54

题解 | 用户购买次数前三

select uid, count(*) as cnt from user_client_log where step in ('order') group by uid order by cnt desc, uid limit 3;

2025-03-18

0 36

题解 | 统计快递从创建订单到发出间隔时长

select round(avg(timestampdiff(minute,a.create_time,b.out_time)/60),3) as time from express_tb as a join exp_action_tb as b on a.exp_numb...

2025-03-18

0 44

题解 | 统计快递运输时长

select a.exp_type, round(avg(timestampdiff(minute,b.out_time,b.in_time)/60),1) as time from express_tb as a join exp_action_tb as b on ...

2025-03-18

0 29

题解 | 查询产生理赔费用的快递信息

select b.exp_number, a.exp_type, b.claims_cost from express_tb as a join exp_cost_tb as b on a.exp_number=b.exp_number where b.clai...

2025-03-18

0 48

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

select c.emp_id, e.emp_level, d.exam_tagfrom exam_record as c join ( select a.exam_id, b.tag as exam_tag, ...

2025-03-18

0 41

题解 | 查询成绩

select count(d.sId) as 'count(*)' from ( select SC.sId, avg(score) from SC inn...

2025-03-15

0 35