题解 | #查询2022年毕业用户的刷题记录#
查询2022年毕业用户的刷题记录
https://www.nowcoder.com/practice/e53e8797213748038a5faeb8563ba27a
select
user_id,
question_type,
device,
pass_count,
date
from
questions_pass_record
where
user_id in(select distinct(user_id) from user_info where graduation_year=2022)