准备进厂的芹菜很伟大

分类

/ 注册

全部文章（共35篇）

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

题解 | 查询成绩

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 73

题解 | 请写出计算粉丝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 75

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

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 77

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

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 108

题解 | 支付间隔平均值

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 60

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

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 62

题解 | 统计加班员工占比

SELECT s.department,CONCAT(ROUND(COALESCE(c.overtime_work,0) /COUNT(*)*100,1),'%') AS ratio FROM staff_tb AS s JOIN attendent_tb AS a ON a.staff_id...

2025-04-11

0 71

题解 | 统计各个部门平均薪资

SELECT st.department ,ROUND(AVG(sa.normal_salary-sa.dock_salary),3) AS avg_salary FROM staff_tb AS st JOIN salary_tb AS sa ON st.staff_id=sa.staff_i...

2025-04-11

0 81

题解 | 查询单日多次下订单的用户信息？

SELECT DATE(order_time) AS order_date , o.user_id, count(*) AS order_nums , u.vip FROM order_tb AS o JOIN uservip_tb AS u ON o.user_id=u.user_id GRO...

2025-04-11

0 67