yyyy11一

分类

/ 注册

全部文章（共87篇）

题解 | 在线教育平台活跃学员课程评价分析

WITH t1 AS ( SELECT * FROM content_reviews WHERE course_id = 'DS-102' ) SELECT t1.user_id, ROUND(AVG(t1.rating), 2) AS average_ra...

2026-02-27

1 33

题解 | 目标月份的品类销售简报

select p.category, count(distinct os.order_id) as orders_cnt, count(distinct od.buyer_id) as buyers_cnt, sum(qty) as items_qty, sum(qty*price) as rev...

2026-02-25

0 28

题解 | 近7天骑手履约时效看板

with t1 as(select max(date(delivered_ts)) as max_d FROM parcel), t2 as( select a.courier_id, courier_name, city, ...

2026-02-23

0 32

题解 | 智能家居设备高能耗异常监控分析

WITH device_monthly_usage AS ( SELECT device_id, SUM(usage_kwh) AS total_usage FROM energy_logs WHERE log_timestamp BET...

2026-02-07

0 39

题解 | 统计借阅量

WITH book_monthly_borrows AS ( SELECT a.book_id, a.book_title, -- 2023年2月借阅量用left选取日期的前七位 COUNT(CASE WHEN LEFT(b....

2026-01-17

0 43

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

SELECT p.product_id, p.product_name, s.total_quantity, r.average_rating FROM products_underline p JOIN ( SELECT pro...

2026-01-11

0 53

题解 | 物流公司想要分析快递小哥的薪资构成和绩效情况

select c.courier_id,c.courier_name, sum(base_salary)+sum(delivery_fee)-sum(expense_amount) total_income from couriers_info c join (select courier_id ,...

2026-01-09

0 33

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

SELECT t1.brand_id, t1.brand_name, ROUND(SUM(t2.return_status)/COUNT(t2.order_id),2) return_rate_July_2024, ROUND(AVG(t3.customer_sat...

2026-01-08

0 31

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

SELECT a.employee_id, b.employee_name, a.performance_score as first_half_2024_score, ROW_NUMBER() OVER (PARTITION BY c.project_name OR...

2026-01-08

0 41

题解 | 电商平台需要对商家的销售业绩、退款情况和客户满意度进行综合评估

SELECT m.merchant_id, m.merchant_name, total_sales_amount, total_refund_amount, average_satisfaction_score FROM merchants_under...

2026-01-05

0 32