冷艳的奶酪在看牛客

分类

/ 注册

全部文章（共7篇）

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

select sum(course1)+sum(course2)+sum(course3) as staff_nums from (select info_id,staff_id,if(course like '%1%',1,0) as course1,if(course like '%2%',1,...

2025-03-02

0 27

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

SELECT user_id, ct.room_id, room_type, DATEDIFF (checkout_time, checkin_time) AS days FROM checkin_tb AS ct JOIN guestroom_tb ...

2025-02-27

0 34

题解 | 分析客户逾期情况

select ct.pay_ability, concat(round(100*count(distinct case when lt.overdue_days is not Null then lt.customer_id end)/count(distinct lt.customer_id),1...

2025-02-26

0 29

题解 | 最长连续登录天数

select user_id,max(连续登入天数) as max_consec_days from (select user_id,max(日期排序)-min(日期排序)+1 as 连续登入天数 from (select user_id, fdate, row_number()over(part...

2025-02-24

0 33

题解 | 每个月Top3的周杰伦歌曲

select* from( select month(fdate) as month, rank()over(partition by month(fdate) order by count(pl.song_id) desc, si.song_id asc )as ranking, song_nam...

2025-02-23

0 28

题解 | 21年8月份练题总数

select count(distinct device_id) as did_cnt,count(question_id) as question_cnt from question_practice_detail where month(date)=8 and year(date)=2021

2025-02-18

0 39

题解 | 浙大不同难度题目的正确率

select qd.difficult_level,sum(if(result='right',1,0))/count(qpd.question_id) as correct_rate from user_profile as up left join question_practice_detai...

2025-02-13

0 43