牛客794288350号

分类

/ 注册

全部文章（共53篇）

题解 | 更新员工信息表

SELECT I.EMPLOYEE_ID, CASE WHEN I.LAST_UPDATE_DT >= U.UPDATE_DT THEN I.POSITION ELSE U.NEW_POSITION END AS POSITION, CA...

2025-06-10

2 51

题解 | 输出播放量最高的视频

SELECT cid, ROUND(MAX(peak_uv),3) as max_peak_uv FROM ( SELECT cid, SUM(tag) over(partition by cid ORDER BY time) as peak...

2025-06-09

0 52

题解 | 每个顾客购买的最新产品名称

SELECT t.customer_id, t.customer_name, t.product_name as latest_order FROM (SELECT c.customer_id, c.customer_name, ...

2025-06-09

0 54

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

SELECT order_id, customer_name, order_date FROM (SELECT o.order_id, c.customer_name, o.order_date, ...

2025-06-05

0 50

题解 | 每个部门薪资排名前两名员工

SELECT e.department, e.employee_name, e.salary FROM ( SELECT department, employee_name, s...

2025-06-04

0 52

题解 | 商品销售总额分布

SELECT CASE WHEN u.pay_method = '' THEN 'error' ELSE u.pay_method END AS pay_method, COUNT(*) as count FROM user_clie...

2025-06-04

0 27

题解 | 商品价格排名

SELECT product_id, product_name, type, price FROM ( SELECT product_id, product_name, t...

2025-06-04

0 37

题解 | 统计快递运输时长

SELECT t.exp_type, ROUND(AVG(TIMESTAMPDIFF(MINUTE,a.out_time,a.in_time)/60.0),1) AS time FROM exp_action_tb a JOIN express_tb t ON a....

2025-06-04

0 32

题解 | 短视频直播间晚上11-12点之间各直播间的在线人数

SELECT u.room_id, r.room_name, COUNT(DISTINCT u.user_id) AS user_count FROM user_view_tb u JOIN room_info_tb r ON u.room_id=r.room_id...

2025-06-04

0 41

题解 | 被重复观看次数最多的3个视频

SELECT sub.cid, ROUND(sub.total_pv, 3) AS pv, sub.rk FROM ( SELECT cid, SUM(user_pv) AS total_pv, ROW_NUMBER()...

2025-06-04

0 50