Sunshine晶晶

分类

/ 注册

全部文章（共86篇）

题解 | 更新员工信息表

WITH t AS ( SELECT EMPLOYEE_ID,UPDATE_DT,NEW_POSITION FROM EMPLOYEE_UPDATE WHERE (EMPLOYEE_ID,UPDATE_DT) IN ( SELECT EMPLOYEE_ID,M...

2026-01-26

0 34

题解 | 统计每个产品的销售情况

WITH t AS ( SELECT p.product_id,SUM(quantity*unit_price) AS total_sales, SUM(quantity) AS total_quantity, SUM(quantity*unit_...

2026-01-21

0 41

题解 | 统计每个产品的销售情况

WITH t AS ( SELECT p.product_id,SUM(quantity*unit_price) AS total_sales, SUM(quantity) AS total_quantity, SUM(quantity*unit_...

2026-01-21

0 43

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

WITH t AS ( SELECT uid,cid,COUNT(*) AS pv FROM play_record_tb GROUP BY uid,cid HAVING COUNT(*)>=2 ), o AS ( SELECT t.cid,SUM(pv) AS...

2026-01-05

0 53

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

SELECT music_name FROM ( SELECT DISTINCT t3.id,t3.music_name FROM follow t1 LEFT JOIN music_likes t2 ON t1.follower_id=t2.user_id LEFT JOIN music t3 O...

2026-01-03

0 58

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

WITH t AS ( SELECT staff_id,normal_salary-dock_salary AS salary FROM salary_tb WHERE normal_salary-dock_salary >=4000 AND normal_salary...

2025-12-31

0 52

题解 | 统计商家不同会员每日访问人次及访问人数

SELECT t2.vip, COUNT(t1.user_id) AS visit_nums, COUNT(DISTINCT t1.user_id) AS visit_users FROM visit_tb t1 LEFT JOIN uservip_tb t2 ON t1...

2025-12-25

0 37

题解 | 每个商品的销售总额

WITH t AS ( SELECT t1.name AS product_name, SUM(t2.quantity) AS total_sales, t1.category, t1.product_id FROM products t1 LEFT JOI...

2025-12-23

0 35

题解 | 每个商品的销售总额

WITH t AS ( SELECT t1.name AS product_name, SUM(t2.quantity) AS total_sales, t1.category, t1.product_id FROM products t1 LEFT JOI...

2025-12-23

0 39

题解 | 推荐内容准确的用户平均评分

WITH t AS ( SELECT SUM( CASE WHEN t1.rec_info_l=t2.hobby_l THEN 1 ELSE 0 END ) AS counts , AVG(t...

2025-12-22

0 43