牛客264897283号

分类

/ 注册

全部文章（共51篇）

题解 | 查找最晚入职员工的所有信息

select emp_no, birth_date, first_name, last_name, gender, hire_date from employees where hire_date in (select max(hire_date) from employees )

2025-03-11

0 63

题解 | 商品销售总额分布

select case when a.pay_method = '' then 'error' else pay_method end as py, count(a.pay_method) as cnt from user_client...

2025-03-11

0 48

题解 | 商品销售排名

select b.product_name, cast(sum(b.price) as signed) as total from user_client_log a left join product_info b using (product_id) where ...

2025-03-11

0 44

题解 | 商品价格排名

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

2025-03-11

0 51

题解 | 用户购买次数前三

select uid,count(trace_id) as cnt from user_client_log where step='order' group by uid order by cnt desc limit 3

2025-03-11

0 50

题解 | 下单最多的商品

select product_id, count(distinct trace_id) as cnt from user_client_log where step = 'order' group by product_id order by coun...

2025-03-11

0 52

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

select round( avg( timestampdiff (minute, a.create_time, b.out_time) / 60 ), 3 ) as time from express_...

2025-03-11

0 42

题解 | 统计快递运输时长

select a.exp_type, round( avg(timestampdiff (second, b.out_time, b.in_time)/3600), 1 ) as time from exp_action_tb b ...

2025-03-10

0 54

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

select b.exp_number, a.exp_type, b.claims_cost from exp_cost_tb b join express_tb a using (exp_number) where b.claims_cost &g...

2025-03-10

0 69

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

with e as ( select *, avg(timestampdiff (second, start_time, submit_time)) over ( partition by ...

2025-03-10

0 49