牛客883499015号

分类

/ 注册

全部文章（共24篇）

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

select round(avg(t.score), 3) as avg_score from( select *, row_number() over(partition by r.rec_user order by u.score) as ranking fro...

2026-03-08

0 22

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

select c.staff_id, s.staff_name from cultivate_tb c join staff_tb s on c.staff_id = s.staff_id where c.course regexp '3' # 查询课表中包含course3的人

2026-03-08

0 20

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

select sum(t.course1 + t.coures2 + t.coures3) as staff_nums from ( select info_id, staff_id, course, sum(if(substring_index(course, ',', ...

2026-03-08

0 21

题解 | 查询连续入住多晚的客户信息？

select c.user_id as user_id, c.room_id as room_id , g.room_type as room_type, datediff(date_format(c.checkout_time,'%Y-%m-%d'), date_...

2026-03-08

0 21