牛客984572812号

分类

/ 注册

全部文章（共17篇）

题解 | 商品价格排名

WITH t1 AS ( SELECT product_id, rank() over(partition by type order by price DESC) rk FROM product_info ) SELECT product_...

2025-02-15

0 90

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

WITH t1 AS ( SELECT exam_id, avg(score) average_score, avg(timestampdiff(second,start_time,submit_time)/60) average_time FROM exa...

2025-02-15

0 69

题解 | 淘宝店铺的实际销售额与客单价

WITH t1 AS ( SELECT s.goods_id, sum(sales_num) * max(goods_price) sales FROM sales_tb s JOIN goods_tb g USING(goods_id) GROUP BY s...

2025-02-15

0 83

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

WITH t1 AS ( SELECT room_id, count(DISTINCT user_id) user_count FROM user_view_tb WHERE hour(in_time) BETWEEN 23 AND 24 OR hour(ou...

2025-02-15

0 70

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

WITH t1 AS ( SELECT uid, cid, count(*) pv FROM play_record_tb GROUP BY uid, cid HAVING count(*) > 1) SELECT t1.cid as...

2025-02-12

0 62

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

SELECT g.id as id, name, weight, sum(count) as total FROM goods g JOIN trans t ON g.id = t.goods_id WHERE weight < 50 GROUP BY g.id, name, weight ...

2025-02-12

0 53

题解 | 支付间隔平均值

WITH t1 AS ( SELECT o.order_id, abs(TIMESTAMPDIFF(second,o.logtime,s.logtime)) as difference FROM order_log o JOIN select_log s USING(orde...

2025-02-12

0 66