题解 | #查询2022年以来刷题用户的#
查询2022年以来刷题用户的用user_id和毕业院校
https://www.nowcoder.com/practice/ea7d9e67f14e4cfc860bbbe9f65420a6?tpId=341&tqId=10100018&ru=/exam/oj&qru=/ta/vip-sql/question-ranking&sourceUrl=%2Fexam%2Foj%3Fpage%3D1%26tab%3DSQL%25E7%25AF%2587%26topicId%3D341
SELECT DISTINCT q.user_id, (SELECT u.university FROM user_info u WHERE q.user_id=u.user_id) as university FROM questions_pass_record q where year(q.date)>='2022';
