牛客404425958号

分类

/ 注册

全部文章（共214篇）

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

with rec_user as( select distinct user_id, rec_info_l, hobby_l, score from recommend_tb left join user_action_tb on rec_user=user_id where rec_info_l...

2024-10-18

0 35

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

with department_cul as ( select a.staff_id, staff_name, course from staff_tb a right join cultivate_tb b on a.staff...

2024-10-18

0 59

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

with t as( select staff_id, if(course like '%1%',1,0) as course1, if(course like '%2%',1,0) as course2, if(course like '%3%',1,0) as ...

2024-10-18

0 44

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

with room_checkin as( select user_id, a.room_id as room_id, room_type, datediff(date(checkout_time),date(checkin_time)) as days f...

2024-10-18

0 41