牛客794288350号

分类

/ 注册

全部文章（共50篇）

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

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

2025-06-05

0 18

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

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

2025-06-04

0 20

题解 | 商品销售总额分布

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 14

题解 | 商品价格排名

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

2025-06-04

0 17

题解 | 统计快递运输时长

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 16

题解 | 短视频直播间晚上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 22

题解 | 被重复观看次数最多的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 15

题解 | 请写出计算粉丝ctr的sql语句

select sum(c.read_num) / sum(c.show_num) as fans_ctr from a join b on a.author_id = b.author_id join c on b.content_id = c.content_id ...

2025-06-03

0 31

题解 | 支付间隔平均值

SELECT CAST(AVG(ABS(timestampdiff(second,ol.logtime,sl.logtime))) AS SIGNED) AS gap FROM order_log ol JOIN select_log sl ON ol.order_id=s...

2025-06-03

0 15

题解 | 每天登陆最早的用户的内容喜好

SELECT T.log_day, ut.user_id, ut.hobby FROM ( SELECT MIN(log_time) AS earliest, DATE(log_time) as l...

2025-06-03

0 19