数分菜鸟求职ing

分类

/ 注册

全部文章（共75篇）

题解 | 查询出不同类别商品中，销售金额排名前三且利润率超过 20%的商品信息

select product_id,product_name,category_id,sales_amount,profit_rate from( select p.product_id,product_name,category_id,sales_amount, rank()ove...

2025-12-17

0 24

题解 | 分析每个商品在不同时间段的销售情况

select p.product_id,product_name,sum(ifnull(total_amount,0)) q2_2024_sales_total, rank()over(partition by category order by sum(total_amount) desc) ca...

2025-12-17

0 23

题解 | 电商平台想要了解不同商品在不同月份的销售趋势

select p.product_id,product_name,sum(quantity) total_sales,max(quantity) max_monthly_sales, min(quantity) min_monthly_sales,round(avg(quantity),0) avg...

2025-12-16

0 27

题解 | 电商平台需要对商家的销售业绩、退款情况和客户满意度进行综合评估

with t1 as( select s1.merchant_id,merchant_name,sum(sale_amount) sale_amount from merchants_underline m join sales_underline s1 on m.merchant...

2025-12-16

0 28

题解 | 对商品的销售情况进行深度分析

with zzh as ( select p.category product_category,c.age_group age_group, sum(s.quantity * s.price) total_sales_amount from products p join ...

2025-12-16

0 30

题解 | 最受欢迎的top3课程

select c.cid, count(c.id) pv, sum(timestampdiff(minute,start_time,end_time)) time_len from play_record_tb p left join course_info_tb c on p.cid = c.c...

2025-12-15

0 21

题解 | 更新员工信息表

with zzh as ( select e2.EMPLOYEE_ID ,UPDATE_DT ,NEW_POSITION , row_number()over(partition by e2.EMPLOYEE_ID order by UPDATE_DT desc) rk fr...

2025-12-10

0 27

题解 | 未下单用户登陆渠道统计

select channel, count(channel) cnt from order_log o right join user_info u on o.uid = u.uid where product_id is null group by channel order by cnt de...

2025-12-09

0 28

题解 | 用户订单信息查询

select city,sum(total_amount) total_order_amount from orders o join customers c on o.customer_id = c.customer_id group by city order by total_order_am...

2025-12-09

0 31

题解 | 未下单用户统计

select count(*) as cnt from user_info where uid not in ( select uid from order_log group by uid )

2025-12-08

0 25