牛客695261949号

分类

/ 注册

全部文章（共92篇）

题解 | 每个商品的销售总额

select name as product_name , total_sales ,row_number()over(partition by category order by total_sales desc ,product_id) as category_rank ...

2025-04-05

0 15

题解 | 统计所有课程参加培训人次

select sum(case when course is null then 0 else length(course) - length(replace(course,',','')) +1 end) as staff_nums f...

2025-04-03

0 19