题解 | #查询2022年毕业用户的刷题记录#
查询2022年毕业用户的刷题记录
https://www.nowcoder.com/practice/e53e8797213748038a5faeb8563ba27a
select q.user_id,
question_type,
device,
pass_count,
date
from questions_pass_record as q
join
(select user_id,graduation_year from user_info) as u
on q.user_id = u.user_id and graduation_year = '2022'
查看11道真题和解析