最爱青草蛋糕

分类

/ 注册

全部文章（共74篇）

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

with t1 as (select o.product_id as product_id,order_date,total_amount,product_name,category from order_info o join product_info p on o.product_id = p....

2025-08-29

0 25

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

with t1 as(select merchants_underline.merchant_id as merchant_id,merchant_name,sum(sale_amount) as total_sales_amount from merchants_underline join sa...

2025-08-28

0 17

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

with t1 as (select p.product_id,category,sale_id,quantity,price from products p join sales s on p.product_id = s.product_id), t2 as ( select c.sale_i...

2025-08-28

0 26

题解 | 最受欢迎的top3课程

with t1 as (select cid,timestampdiff(second,start_time,end_time)/60 as count_time,score from play_record_tb where date(start_time) < '2022-01-09') ...

2025-08-27

0 17

题解 | 用户订单信息查询

with t1 as (select c.customer_id,city,total_amount from customers c join orders o on c.customer_id = o.customer_id) select city,sum(total_amount) as ...

2025-08-22

0 22

题解 | 未下单用户统计

with t1 as (select u.uid from user_info u left join (select uid from order_log group by uid) as b on u.uid = b.uid where b.uid is null) select count(u...

2025-08-22

0 28

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

with t1 as (select cust_name,c.cust_id as cust_id,order_num from Customers c join Orders on c.cust_id = Orders.cust_id), t2 as (select t1.order_num a...

2025-08-22

0 23

题解 | 输出播放量最高的视频

with t1 as (select cid,start_time as count_time, 1 as count_num from play_record_tb union all select cid,end_time as count_time, -1 as count_num from ...

2025-08-21

0 12

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

#表1和2结合 with t1 as(select orders.customer_id as customer_id,product_id,customer_name, rank()over(partition by customer_id order by order_date desc) as...

2025-08-21

0 17

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

select t12.product_id,total_sales,unit_price,total_quantity,avg_monthly_sales,max_monthly_quantity,customer_age_group from (select product_id,customer...

2025-08-20

0 23