查询2022年以来刷题用户的用user_id和毕业院校
查询2022年以来刷题用户的用user_id和毕业院校
https://www.nowcoder.com/practice/ea7d9e67f14e4cfc860bbbe9f65420a6
select
user_id,
university
from
user_info
where
EXISTS (
select
user_id
from
questions_pass_record
where
questions_pass_record.user_id = user_info.user_id and year(date) = '2022'
)
查看14道真题和解析