查询1997，1999年出生的同学信息，正确的SELECT语句是( )。

A．SELECT * FROM student WHERE YEAR(birthday) NOT IN(1997, 1999);
B．SELECT * FROM student WHERE YEAR(birthday) IN(1997, 1999);
C．SELECT * FROM student WHERE YEAR(birthday)=1997 AND YEAR(birthday)=1999;
D．SELECT * FROM student WHERE YEAR(birthday) EXISTS(1997, 1