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

A．SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID ASC; 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 = ‘1978’ AND year = ‘1997’ AND year = ‘2008’ ORDER BY mID DESC;

时间：2023-12-29 09:41:47