谦虚的比尔在炒股

分类

/ 注册

TA的专栏 0篇文章 0人订阅

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共88篇）

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

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

2025-06-18

0 42

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

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

2025-06-18

0 48

题解 | 商品销售总额分布

select pay_method, count(*) as cnt from ( select if(pay_method = '','error',pay_method) as pay_method from ...

2025-06-18

0 34

题解 | 商品销售排名

select * from ( select pi.product_name, pi.price * a.cnt as total_price from product_info as pi left j...

2025-06-18

0 44

题解 | 商品价格排名

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

2025-06-18

0 44

题解 | 用户购买次数前三

select uid, count(if(step = 'order',1,null)) as cnt from user_client_log group by uid order by cnt desc, ...

2025-06-18

0 65

题解 | 下单最多的商品

select product_id, count(product_id) as cnt from user_client_log where step = 'order' group by product_id o...

2025-06-17

0 30

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

select round(avg(timestampdiff(minute,create_time,out_time)) / 60 ,3) as time from express_tb as et left join exp_action_tb ...

2025-06-17

0 26

题解 | 统计快递运输时长

select exp_type, round(avg(timestampdiff(minute,out_time,in_time) / 60),1) as time from express_tb as et left join ...

2025-06-17

0 22

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

select ect.exp_number, exp_type, claims_cost from exp_cost_tb as ect left join express_tb as et on ...

2025-06-17

0 19