Lateral

分类

/ 注册

全部文章（共146篇）

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

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

2025-03-25

0 54

题解 | 商品销售总额分布

select t1.pay_method, count(*) as cnt from (select case when u.pay_method<>'' then u.pay_method else 'error' end as pay_method from user_client...

2025-03-25

0 49

题解 | 商品销售排名

select p.product_name, p.price*count(p.product_name) as total_sales from user_client_log u left join product_info p on u.product_id=p.product_id where...

2025-03-24

0 61

题解 | 商品价格排名

select t1.product_id, t1.product_name, t1.type, t1.price from (select product_id, product_name, type, ...

2025-03-24

0 39

题解 | 用户购买次数前三

select uid, count(step) as cnt from user_client_log where step='order' group by uid order by row_number() over(partit...

2025-03-24

0 51

题解 | 用户购买次数前三

select uid, count(step) as cnt from user_client_log where step='order' group by uid order by row_number() over(partition by uid order by count(step) a...

2025-03-24

0 51

题解 | 下单最多的商品

select u.product_id, count(u.step) as cnt from user_client_log u left join product_info p on u.product_id=p.product_id where u.step='order' group by u...

2025-03-24

0 36

题解 | 统计快递从创建订单到发出间隔时长

select round(avg(timestampdiff(minute,e.create_time,a.out_time)/60),3) as time from express_tb e left join exp_action_tb a on e.exp_number=a.exp_numbe...

2025-03-24

0 43

题解 | 统计快递运输时长

select t.exp_type, round(avg(t.time)/3600,1) as time from (select e.exp_type, timestampdiff(second,a.out_time,a.in_time) a...

2025-03-24

0 54

题解 | 查询产生理赔费用的快递信息

select e.exp_number, e.exp_type, c.claims_cost from express_tb e left join exp_cost_tb c on e.exp_number=c.exp_number where c.claims_cost is not null ...

2025-03-24

0 48