牛客479560235号

分类

/ 注册

全部文章（共75篇）

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

SELECT AVG(score) FROM user_action_tb WHERE user_id IN( SELECT DISTINCT t1.rec_user FROM recommend_tb t1 INNER JOIN user_action_tb t2 ...

2025-03-24

0 37

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

SELECT * FROM( SELECT t1.user_id, t1.room_id, t2.room_type, CEIL(TIMESTAMPDIFF(HOUR,checkin_time,checkout_time)/24) days FROM...

2025-03-21

0 52

题解 | 获取指定客户每月的消费额

SELECT DATE_FORMAT(t1.t_time,'%Y-%m') time, SUM(t1.t_amount) total FROM trade t1,customer t2 WHERE t2.c_name = 'Tom' AND t1.t_time BETWEEN '2023-01-0...

2025-03-18

0 72

题解 | 分析客户逾期情况

WITH t3 AS( SELECT t2.pay_ability, COUNT(t1.customer_id) cnt_c, SUM(IF(t1.overdue_days IS NULL,0,1)) s_c FROM loan_tb t1,customer...

2025-03-18

0 73

题解 | 最长连续登录天数

SELECT t3.user_id,MAX(t3.c_consec_days) max_consec_days FROM ( SELECT t2.user_id,t2.d_sub,COUNT(t2.d_sub) c_consec_days FROM( SELECT t...

2025-03-18

0 52

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

SELECT a.month, a.ranking, b.song_name, a.play_pv FROM( SELECT MONTH(fdate) month, song_id, ROW_NUMBER() OVER(partition by MONTH(fda...

2025-03-14

0 52

题解 | 网易云音乐推荐(网易校招笔试真题)

SELECT sub_t.music_name FROM( SELECT DISTINCT a.music_id,b.music_name FROM music_likes a INNER JOIN music b ON a.music_id = b.id W...

2025-02-24

0 61

题解 | 获得积分最多的人(三)

SELECT b.id, b.name, r_table.grade_num FROM( SELECT a.user_id, a.grade_num, RANK() OVER(order by a.grade_num DESC) g_rank FROM( ...

2025-02-23

0 64

题解 | 获得积分最多的人(二)

SELECT b.user_id,c.name,b.grade_num FROM( SELECT a.user_id, a.grade_num, DENSE_RANK() OVER(order by a.grade_num DESC) r_l FROM( ...

2025-02-21

0 51

题解 | 获得积分最多的人(一)

SELECT b.name,MAX(a.grade_num) grade_num FROM( SELECT user_id,SUM(grade_num) OVER(partition by user_id) grade_num FROM grade_info ) a INNER JO...

2025-02-21

0 59