SELECT语句只能进行数据查询，不能进行计算。

A.IN

B.NOT IN

C.BETWEEN

D.NOT BETWEEN

A.WHERE

B.HAVING

C.GROUP BY

D.FROM

A.SELECT year，director FROM Movie

B.SELECT mID，title FROM Movie

C.SELECT director，year FROM Movie

D.SELECT director，mID FROM Movie

A.SELECT * FROM student WHERE YEAR(birthday) NOT IN(1997, 1999);

B.SELECT * FROM student WHERE YEAR(birthday)=1997 AND YEAR(birthday)=1999;

C.SELECT * FROM student WHERE YEAR(birthday) IN(1997, 1999);

D.SELECT * FROM student WHERE YEAR(birthday) EXISTS(1997, 1999);

A.DELETE

B.UPDATE

C.SELECT

D.INSERT