Lateral

分类

/ 注册

全部文章（共102篇）

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

with t as( select p.product_id, p.product_name, s.sale_month, s.quantity as monthly_sales, sum(s.quantity)...

2025-07-04

0 11

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

with sales as( select merchant_id, sum(sale_amount) as total_sales_amount from sales_underline group by merchant_id), r...

2025-07-04

0 10

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

with t1 as( select p.category as product_category, c.age_group as age_group, sum(s.quantity*s.price) as total_group_sales...

2025-07-04

0 11

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

with t1 as( select p.category as product_category, c.age_group as age_group, sum(s.quantity*s.price) as total_group_sales...

2025-07-04

0 10

题解 | 获得积分最多的人(三)

with t as (select u.id,u.name, case when g.type='add' then g.grade_num else -1*g.grade_num e...

2025-06-30

0 16

题解 | 获得积分最多的人(一)

select t.name, t.grade_num from (select u.name as name, sum(g.grade_num) as grade_num from user u right join grade_info g on ...

2025-06-30

0 18

题解 | 最差是第几名(二)

WITH final_ranks AS ( SELECT grade, total_num, end_rank, COALESCE(LAG(end_rank) OVER(ORDER BY grade ASC), 0) + 1...

2025-06-30

0 16

题解 | 最差是第几名(一)

select t1.grade, sum(t1.number) over(order by t1.grade asc rows between unbounded preceding and current row) as t_rank from (select * from cla...

2025-06-27

0 18

题解 | 实习广场投递简历分析(三)

with month_info as( select job,date,num, substr(date,1,7) as mon from resume_info), t1 as( se...

2025-06-27

0 20

题解 | 实习广场投递简历分析(二)

select t1.job, concat('2025-',t1.mon) as mon, sum(t1.num) as cnt from (select job, num, substr(date,6,2) as mon from resume_in...

2025-06-26

0 19