题解
查询2022年以来刷题用户的用user_id和毕业院校
https://www.nowcoder.com/practice/ea7d9e67f14e4cfc860bbbe9f65420a6
SELECT u.user_id, u.university
FROM user_info AS u
WHERE u.user_id in (
SELECT q.user_id
FROM questions_pass_record AS q
WHERE YEAR(`date`) >= 2022
)
查看3道真题和解析
投递腾讯云智研发等公司6个岗位 >
