呼吸丶zero

分类

/ 注册

全部文章（共42篇）

题解 | 贷款情况

select city ,total_loan_amount ,average_loan_amount ,total_customers ,loan_type_name as most_applied_loan_type from ( select city ,round(sum(l...

2025-07-22

16 77

题解 | 查询出每个品牌在特定时间段内的退货率以及平均客户满意度评分

select brand_id ,brand_name ,round(sum(return_status)/count(*),2) as return_rate_July_2024 ,round(avg(customer_satisfaction_score),2) as average_custo...

2025-07-22

2 66

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

select employee_id, employee_name, performance_score as first_half_2024_score, row_number() over ( partition by pro...

2025-07-21

0 85

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

with t as ( select product_id, product_name, sum(total_amount) as q2_2024_sales_total, cat...

2025-07-20

0 69

题解 | 最受欢迎的top3课程

select cid, count(*) as pv, floor(sum(tl)) as time_len from ( select cid, timestampdiff(second, start...

2025-07-18

3 73

题解 | 未下单用户统计

select cast(sum(case when product_id is null then 1 else 0 end) as signed ) as cnt from order_log right join user_info using(uid)

2025-07-16

0 52

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

WITH daily_events AS ( SELECT cid, DATE(event_time) AS dt, event_time, event_type FROM ( -- 生成开始事件 ...

2025-07-15

0 92

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

select customer_id ,customer_name ,product_name as latest_order from orders join customers using(customer_id) join products using(product_id) where (c...

2025-07-15

0 108

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

select order_id, customer_name, order_date from orders join customers using (customer_id) where order_date in ( select...

2025-07-14

0 64

题解 | 商品销售总额分布

select case when u.pay_method = '' then 'error' else u.pay_method end as pay_method, count(*) as num from user_client_...

2025-07-13

1 72