查询1997,1999年出生的同学信息,正确的SELECT语句是______
A.SELECT * FROM student WHERE YEAR(birthday) NOT IN(1997,1999)
B.SELECT * FROM student WHERE YEAR(birthday)=1997 OR YEAR(birthday)=1999
C.SELECT * FROM student WHERE YEAR(birthday) IN(1997,1999)
D.SELECT * FROM student WHERE YEAR(birthday) EXISTS(1997,1999)