重生之各大厂争着抢我

分类

/ 注册

全部文章（共48篇）

题解 | 贷款情况

with a as( select city, sum(loan_amount) as total_loan_amount, round(sum(loan_amount)/count(distinct customer_id),2) as a...

2026-01-13

0 45

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

select employee_id,department_name ,performance_score from ( select department_id ,avg(performance_score ) as avg_score from employee_projects...

2026-01-12

0 43

题解 | 查询出每个运输方式在不同城市的平均运输时长以及总运输费用

select destination_city, transport_name, round( avg(timestampdiff(day,order_date,delivery_date )),2) as average_transport_duration, ...

2026-01-12

0 58

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

select e.employee_id, employee_name, performance_score as first_half_2024_score, rank() over(partition by project_id order by perform...

2026-01-12

0 60

题解 | 查询出不同类别商品中，销售金额排名前三且利润率超过 20%的商品信息

with a as( select product_id, product_name, category_id, sales_amount, round((sales_amount-cost_amount)/s...

2026-01-12

0 47

题解 | 分析每个商品在不同时间段的销售情况

select product_id, product_name, sum(case when order_date between '2024-04-01' and '2024-06-30' then total_amount else 0 end) as q2_2024_...

2026-01-10

0 36

题解 | 最受欢迎的top3课程

with a as( select cid from play_record_tb group by cid having avg(score)>=3 ) select cid, count(*) as pv, sum(timestampdiff...

2026-01-10

0 51

题解 | 更新员工信息表

select EMPLOYEE_ID , case when UPDATE_DT>LAST_UPDATE_DT then NEW_POSITION else POSITION end as POSITION , case when UPDATE_DT>LAST_UP...

2026-01-09

0 47

题解 | 每个顾客购买的最新产品名称

select customer_id,customer_name,product_name as latest_order from ( select customer_id,product_id,order_date, rank() over(partition by cu...

2026-01-09

0 39

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

select order_id,customer_name,order_date from( select customer_name,customer_id,max(order_date) as order_date from orders join customers using...

2026-01-09

0 45