Tendernessnick

分类

/ 注册

全部文章（共114篇）

题解 | 用户订单信息查询

# 城市总额 with t1 as( select city, sum(total_amount) as total_order_amount from orders left join customers using(customer...

2025-11-20

0 19

题解 | 未下单用户统计

with t1 as( select uid, order_id from user_info left join order_log using(uid) ) , t2 as( select count(dis...

2025-11-20

0 15

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

with t1 as( select customer_id, customer_name, product_name, rank()over(partition by customer_id order by order_da...

2025-11-20

0 14

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

with t1 as( select staff_id, department, staff_gender, normal_salary-dock_salary as actual_salary from ...

2025-11-20

0 14

题解 | 统计每个产品的销售情况

with t1 as( # 产品编号、单价、总销售量、总销售额、月平均销售额 select product_id, unit_price, sum(quantity) as total_quantity, sum(quanti...

2025-11-20

0 23

题解 | 商品id数据清洗统计

with t1 as( select substring_index(order_id,'_',-1) as product_id from order_log ) , t2 as( select product_id, ...

2025-11-19

0 17

题解 | 查询订单

with t1 as( select order_id, customer_name, order_date, rank()over(partition by customer_id order by order_date de...

2025-11-19

0 22

题解 | 每个部门薪资排名前两名员工

with t1 as( select department, employee_name, salary, rank()over(partition by department order by salary desc) as ...

2025-11-19

0 14

题解 | 每个客户的账户总金额

select customer_id, sum(balance) as sum_balance from account group by customer_id order by sum_balance desc, customer_id

2025-11-19

0 14

题解 | 商品销售总额分布

with t1 as( select pay_method, count(pay_method) as cnt from user_client_log left join product_info using(product_id) ...

2025-11-19

0 18