准备进厂的芹菜很伟大

分类

/ 注册

全部文章（共28篇）

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

SELECT e.emp_id,emp_level,tag AS emp_tag FROM exam_record AS e JOIN examination_info AS ex ON e.exam_id = ex.exam_id JOIN em...

2025-04-22

0 34

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

SELECT SUM(sales_num*goods_price)*1.000 AS sales_total , ROUND(SUM(sales_num*goods_price)/COUNT(DISTINCT user_id),3) AS per_trans FROM sales_tb AS s ...

2025-04-22

0 26

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

SELECT u.room_id,room_name,COUNT(DISTINCT user_id) AS user_count FROM user_view_tb AS u JOIN room_info_tb AS r on u.room_id = r.room_id where (time(i...

2025-04-22

0 32

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

SELECT a.cid,pv,rk FROM ( SELECT p.cid,COUNT(p.uid)*1.000 AS pv,ROW_NUMBER() OVER(ORDER BY COUNT(p.uid) DESC, c.release_date DESC ) AS rk FROM play_r...

2025-04-17

0 27

题解 | 查询成绩

SELECT count(*) FROM ( SELECT sname FROM SC JOIN Student AS s ON s.sId = SC.sId JOIN Course AS c ON c.cId = SC.cId GROUP BY sname HAVING AV...

2025-04-15

0 31

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

SELECT SUM(read_num)/SUM(show_num) AS fans_ctr FROM b join a on b.author_id=a.author_id join c on b.content_id = c.content_id WHERE a.fans_id ...

2025-04-15

0 35

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

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

2025-04-15

0 30

题解 | 网易云音乐推荐(网易校招笔试真题)

SELECT music_name FROM ( SELECT DISTINCT music_name ,id FROM music_likes AS m_l JOIN music AS m ON m_l.music_id=m.id WHERE m_l.user_id IN ( SELECT fo...

2025-04-13

0 43

题解 | 支付间隔平均值

SELECT CAST(AVG(ABS(TIMESTAMPDIFF(SECOND,o.logtime,s.logtime)) ) AS UNSIGNED) AS gap FROM order_log AS o JOIN select_log AS s ON o.order_id = s.ord...

2025-04-13

1 30

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

SELECT DATE(log_time) AS log_day, l.user_id,u.hobby FROM login_tb AS l JOIN user_action_tb AS u ON u.user_id=l.user_id WHERE log_time IN ( SELECT MIN(...

2025-04-13

0 25