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

# select user_id from user_info where graduation_year = 2022

# SELECT
# 	* 
# FROM
# 	questions_pass_record AS qpr 
# WHERE
# 	qpr.user_id IN ( SELECT u.user_id FROM user_info AS u WHERE u.graduation_year = 2022 )

SELECT
	qpr.user_id,
	qpr.question_type,
	qpr.device,
	qpr.pass_count,
	qpr.date 
FROM
	questions_pass_record AS qpr
	INNER JOIN user_info AS ui ON qpr.user_id = ui.user_id 
WHERE
	ui.graduation_year = 2022