题解 | 4种

> exists

select
    t1.user_id,
    t1.university
from
    user_info t1
where exists (
    select 1 from questions_pass_record t2
    where t1.user_id = t2.user_id and year(t2.date) >= 2022
)

> join

select
    t1.user_id,
    t1.university
from
    user_info t1
    join questions_pass_record t2 on t1.user_id = t2.user_id
where 
    year(t2.date) >= 2022

> 如果数据记录表比较大

select
    t2.user_id,
    t2.university
from (
    select distinct user_id from questions_pass_record where year(date) >= 2022
) t1
join user_info t2 on t1.user_id = t2.user_id

select
    user_id,
    university
from
    user_info
where 
    user_id in (
        select distinct user_id from questions_pass_record where year(date) >= 2022
    )