题解 | #查询2022年毕业用户的刷题记录#

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'