存几分期许

分类

/ 注册

全部文章（共167篇）

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

select product_id, count(1) as cnt from ( select substring_index(order_id, '_', -1) as product_id from order_log ) temp group by product_id or...

2025-08-09

1 57

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

with latest_order as ( select order_id, customer_id, order_date from ( select order_id, customer_id, order_date, row_number() ...

2025-08-09

0 34

题解 | 查询订单

with t as ( select customer_id, max(order_date) as latest_date from orders group by customer_id ) select order_id, customer_name, order_da...

2025-08-08

0 44

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

select department, employee_name, salary from ( select employee_name, department, salary, rank() over (partition by department order by salary...

2025-08-08

0 39

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

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

2025-08-08

0 25

题解 | 商品销售总额分布

select pay_method_new, count(1) as cnt from ( select product_id, pay_method, case when (pay_method is null or pay_method='') then 'error' else...

2025-08-08

1 33

题解 | 商品销售排名

select product_name, cast(sum(price) as signed) as price from user_client_log a join product_info b on a.product_id=b.product_id where s...

2025-08-08

1 26

题解 | 商品价格排名

with t as ( select product_id, product_name, type, price from ( select product_id, price, type, product_name, dense_rank() ove...

2025-08-08

0 21

题解 | 用户购买次数前三

select uid, count(1) as cnt from user_client_log where step='order' group by uid order by count(1) desc, uid limit 3

2025-08-08

0 28

题解 | 下单最多的商品

select product_id, count(1) as cnt from user_client_log where step='order' group by product_id order by count(1) desc, product_id limit 1

2025-08-08

0 37