Neumann_tz

分类

/ 注册

全部文章（共4篇）

题解 | #获取当前薪水第二多的薪水salary#

SELECT e.emp_no, sub.salary AS second_highest_salary, e.last_name, e.first_name FROM employees e JOIN (SELECT s1.emp_no, s1...

2024-10-30

0 76

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

最长连续登录天数 select distinct b.user_id,b.max_consec_days from ( select a.user_id, max(a.max_contiday) over(partition by a.user_id) as max_consec...

2024-09-21

1 138

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

select avg(b.score) as avg_score from (select * from (select if(rt.rec_info_l=uat.hobby_l,1,0) as yes_or_no, uat.score, uat.hobby_l from recommend_t...

2024-09-19

0 95

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

首先，我们需要先对21年8月份进行表的筛选，代码如下： select * from question_practice_detail where month(date)=8 and year(date)=2021 接着，我们需要从上述21年8月份的表中，按device_id分组，统计总用户数和练...

2024-09-18

0 207