要查出所有在1978，1997，2008年上映的电影的标题并以电影的编号降序输出，SQL语句为——
选项：

A:SELECT title FROM Movie WHERE year = ‘1978’ AND year = ‘1997’ AND year = ‘2008’ ORDER BY mID DESC;
B:SELECT title FROM Movie WHERE year = ‘1978’ OR year = ‘1997’ OR year = ‘2008’ ORDER BY mID ASC;
C:SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID DESC;
D:SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID ASC;