数分菜鸟求职ing

分类

/ 注册

全部文章（共75篇）

题解 | 返回顾客名称和相关订单号以及每个订单的总价

select c.cust_name,o1.order_num,quantity * item_price OrderTotal from Customers c join Orders o1 on c.cust_id = o1.cust_id join OrderItems o2 on o1...

2025-12-08

0 31

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

select customer_id,customer_name,latest_order from ( select o.customer_id,customer_name,product_name latest_order, rank()over(partition by cus...

2025-12-02

0 34

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

select department, ifnull(round(avg(normal_salary - dock_salary),2),0.00) average_actual_salary, ifnull(round(sum(if(staff_gender = 'male',normal_sala...

2025-12-02

0 32

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

with s1 as ( select p.product_id, sum(unit_price*quantity) total_sales, unit_price, sum(quantity) total_quantity, round(sum(unit_p...

2025-11-30

0 28

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

select order_id,customer_name,order_date from ( select order_id,customer_name,order_date, rank()over(partition by o.customer_id order by orde...

2025-11-30

0 26

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

select distinct right(order_id,4) product_id,count(order_id) cnt from order_log group by product_id

2025-11-30

0 31

题解 | 查询订单

select order_id,customer_name,order_date from ( select order_id,customer_name,order_date, rank()over(partition by customer_name order by order...

2025-11-30

0 27

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

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

2025-11-30

0 27

题解 | 商品价格排名

select product_id,product_name,type,price from ( select product_id,product_name,type,price, rank()over(partition by type order by price desc) ...

2025-11-29

0 28

题解 | 用户购买次数前三

select uid,count(distinct trace_id) cnt from user_client_log u group by uid order by cnt desc,uid limit 3

2025-11-29

0 33