牛客768350767号

分类

/ 注册

全部文章（共17篇）

题解 | 电商平台需要对商品的销售和评价情况进行综合分析

with s as( select product_id,sum(quantity) as s_quantity from sales_underline where year(sale_date)=2024 group by product_id), r as( select produ...

2025-07-18

0 12

题解 | 电商平台需要对商品的销售和评价情况进行综合分析

with s as( select product_id,sum(quantity) as s_quantity from sales_underline where year(sale_date)=2024 group by product_id), r as( select produ...

2025-07-18

0 11

题解 | 电商平台想要查询出每个商品在 2024 年上半年（1 月至 6 月）的总销售额

select p.product_id,p.product_name, round(sum(p.price*s.quantity),2) as total_sales from products_underline p left join sales_underline s on p.product...

2025-07-17

0 9

题解 | 电商平台需要对各行业销售情况综合评估

select m.industry,sum(s.sale_amount) as total_sales_amount from merchants_underline m left join sales_underline s on m.merchant_id=s.merchant_id group...

2025-07-17

0 7

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

with o as( select*from order_info where date_format(order_date,'%Y-%m') between '2024-04' and '2024-06') select p.product_id,p.product_name,sum(ifnull...

2025-07-11

0 10

题解 | 更新员工信息表

with u1 as( select EMPLOYEE_ID,UPDATE_DT,NEW_POSITION,row_number()over(partition by EMPLOYEE_ID order by UPDATE_DT desc) as rk from EMPLOYEE_U...

2025-07-10

0 14

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

with u as( select distinct uid,channel from user_info where uid not in (select uid from order_log)) select channel,count(*) as cnt from u grou...

2025-07-10

0 14

题解 | 未下单用户统计

select count(distinct uid) as count from user_info where uid not in (select distinct uid from order_log)

2025-07-09

0 19

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

with o as( select customer_id,product_id,row_number()over(partition by customer_id order by order_date desc) as rk from orders) select o.c...

2025-07-09

0 13

题解 | 查询订单

with o as( select order_id,customer_id,order_date,row_number()over(partition by customer_id order by order_date desc) as rk from orders) select o.orde...

2025-07-08

0 17