壹壹风荷举

分类

/ 注册

全部文章（共61篇）

题解 | 分析不同门店各类商品的库存情况和销售情况

select i.store_id,store_name,product_category,inventory_quantity, sales_amount from sales_inventory i join stores s on s.store_id=i.store_id join pro...

2025-11-09

0 10

题解 | 分析员工在不同项目中的绩效表现以及所属部门的平均绩效情况

with avg_score as ( select department_name,avg(performance_score) as avg_score from department_info d join employee_projects e on e.employee_id =d.emp...

2025-11-09

0 12

题解 | 电商平台需要对商品的销售和评价情况进行综合分析

with q_temp as ( select p.product_id,product_name,sum(quantity) as total_quantity from products_underline p join sales_underline s on s.product_id=p...

2025-11-09

0 12

题解 | 分析每个员工在不同项目中的绩效情况

with per_temp as ( SELECT e.employee_id,employee_name,performance_score,project_id,department from employees e left join performance pe on pe.employe...

2025-11-09

0 9

题解 | 更新员工信息表

SELECT ei.EMPLOYEE_ID, -- 如果 eu.EMPLOYEE_ID 是 NULL (表示该员工无更新记录)，则直接用主表职位。 -- 否则，比较日期，决定使用新职位还是旧职位。 CASE WHEN eu.EMPLOYEE_ID IS...

2025-09-21

0 20

题解 | 输出播放量最高的视频

-- 1. 将播放记录的起止时间(start/end)拆解为+1和-1的离散事件流。 WITH events AS ( SELECT cid, start_time as event_time, 1 as event_type FROM play_record_tb UNIO...

2025-09-20

0 17

题解 | 输出播放量最高的视频

WITH time_points AS ( -- 收集所有可能的关键时间点 SELECT DISTINCT cid, start_time as check_time FROM play_record_tb UNION SELECT DISTINCT cid...

2025-09-20

0 20

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

with temp1 as ( select avg(score) over ( partition by exam_id ) as avg_score, ...

2025-09-20

0 17

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

with temp as ( select follower_id from follow where user_id=1 ), temp1 as ( SELECT DISTINCT music_id from music_likes ml join temp f o...

2025-09-18

0 30

题解 | 统计加班员工占比

with temp as ( select department,sum(case when timestampdiff(second,first_clockin,last_clockin)/3600>9.5 then 1 else 0 end) as ot_count ,count(*)...

2025-09-15

0 27