数分菜鸟求职ing
数分菜鸟求职ing
全部文章
分类
归档
标签
去牛客网
登录
/
注册
数分菜鸟求职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
首页
上一页
1
2
3
4
5
6
7
8
下一页
末页