select user_id,university from user_info where user_id in( select user_id from questions_pass_record where year(date) >= 2022); 将date转化为数值; select user_id,university from user_info where user_id in( select user_id from questions_pass_record where date like "2022%"); //模糊匹配