存几分期许

分类

/ 注册

全部文章（共167篇）

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

SELECT ROUND(AVG(score), 3) AS avg_score FROM (SELECT DISTINCT user_id, rec_info_l, score FROM recommend_tb r JOIN user_action_tb...

2024-08-17

0 127

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

SELECT c.staff_id, staff_name FROM staff_tb s JOIN cultivate_tb c ON s.staff_id = c.staff_id WHERE course LIKE '%course3%' ORDER BY staff_id;

2024-08-17

0 123

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

SELECT SUM(LENGTH(course) - LENGTH(REPLACE(course, ',', '')) + 1) AS staff_nums FROM cultivate_tb;

2024-08-17

0 118

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

SELECT DATE_FORMAT(t_time, '%Y-%m') time, SUM(t_amount) total FROM customer c LEFT JOIN trade t ON c.c_id = t.t_cus WHERE c_name = 'TOM' AN...

2024-08-17

0 129

题解 | #分析客户逾期情况#

SELECT pay_ability, CONCAT(ROUND(COUNT(IF(overdue_days IS NOT NULL, overdue_days, NULL)) / COUNT(1) * 100, 1), '%') AS overdue_ratio FROM loan_...

2024-08-11

0 114

题解 | #最长连续登录天数#

SELECT user_id, consec_days AS max_consec_days FROM (SELECT user_id, consec_days, ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY consec_days DESC ) ...

2024-08-11

2 150

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

SELECT * FROM (SELECT month, ROW_NUMBER() OVER (PARTITION BY month ORDER BY play_pv DESC ,song_id) AS ranking, song_name, ...

2024-08-11

0 110