谦虚的比尔在炒股

分类

/ 注册

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

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共82篇）

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

select one.product_id, one.total_sales, one.unit_price, one.total_quantity, one.avg_monthly_sales, one...

2025-06-19

0 16

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

select od.order_id, c.customer_name, a.order_date from ( select customer_id, max(order_date) as order_date...

2025-06-19

0 19

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

select product_id, count(a.product_id) as cnt from ( select substr(order_id,6,4) as product_id from order...

2025-06-19

0 15

题解 | 查询订单

select od.order_id, c.customer_name, max_order_date as order_date from ( select customer_id, max(order_dat...

2025-06-19

0 14

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

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

2025-06-18

0 25

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

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

2025-06-18

0 22

题解 | 商品销售总额分布

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

2025-06-18

0 20

题解 | 商品销售排名

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

2025-06-18

0 30

题解 | 商品价格排名

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

2025-06-18

0 23

题解 | 用户购买次数前三

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 23