黑桃老七

分类

/ 注册

全部文章（共3篇）

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

select t1.staff_id, t1.staff_name from staff_tb t1 join cultivate_tb t2 on t1.staff_id = t2.staff_id where t2.course like '%course...

2025-05-19

1 100

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

select t2.user_id, t2.room_id, t1.room_type, DATEDIFF (left (checkout_time, 10), left (checkin_time, 10)) as days from guestroom_t...

2025-05-16

0 86

题解 | 分析客户逾期情况

select t3.pay_ability, concat (format (t3.overdue_ratio * 100, 1), '%') overdue_ratio from ( select t1.pay_ability, ...

2025-05-15

0 105