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'
)

京公网安备 11010502036488号