米淇妙妙屋

分类

/ 注册

全部文章（共13篇）

题解 | 贷款情况

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

2025-10-22

0 24

题解 | 哪些产品在特定时间段内表现最为出色

select product_id,product_name,total_sales_amount,total_sales_quantity from ( select product_id,product_name,sum(sales_amount) as total_sales_amo...

2025-09-29

0 24

题解 | 评估不同供应商提供的零部件质量和成本情况

select supplier_id,supplier_name,component_name,quality_score,cost from supply_quality_cost join components using(component_id) join suppliers using(s...

2025-09-28

0 25

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

select destination_city,transport_name,round(avg(delivery_date-order_Date),2) as average_transport_duration,round(sum(total_cost),2) as total_transpor...

2025-09-28

0 25

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

select brand_id,brand_name,round(avg(return_status),2) as return_rate_July_2024, round(avg(customer_satisfaction_score),2) as average_customer_satisf...

2025-09-26

0 23

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

select employee_id,employee_name ,first_half_2024_score, row_number()over(partition by project_group order by first_half_2024_score desc,employee_id a...

2025-09-26

0 22

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

select product_id,product_name,category_id,sales_amount,profit_rate from (select product_id,product_name,category_id,sales_amount,round(1-(cost_amoun...

2025-09-26

0 25

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

with a as (select * from order_info where month(order_date) between 4 and 6), b as (select product_id,product_name,ifnull(sum(total_amount),0) as...

2025-09-26

0 28

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

select merchant_id,merchant_name,total_sales_amount,total_refund_amount,average_satisfaction_score from (select merchant_id,sum(sale_amount) as tota...

2025-09-26

0 26

题解 | 更新员工信息表

select EMPLOYEE_ID,POSITION,LAST_UPDATE_DT from (select EMPLOYEE_ID,POSITION,LAST_UPDATE_DT ,row_number() over (partition by EMPLOYEE_ID order by LA...

2025-09-25

0 20