牛客732134802号

分类

/ 注册

全部文章（共3篇）

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

select a.name as product_name,sum(b.quantity) as total_sales,row_number() over(partition by a.category order by sum(b.quantity) desc) as category_rank...

2025-03-24

0 92

题解 | 推荐内容准确的用户平均评分

select round(avg(b.score),3) as avg_score from recommend_tb ajoin user_action_tb b on a.rec_user=b.user_id and a.rec_info_l=b.hobby_l

2025-03-24

0 91

题解 | 查询培训指定课程的员工信息

select a.staff_id,a.staff_name from staff_tb ajoin cultivate_tb b on a.staff_id=b.staff_idwhere find_in_set('course3',b.course)>0order by a.staff_i...

2025-03-24

0 91