已知影片评论数据库包括如下表结构：Movie ( mID, title, year, director )影片表，属性包括影片编号，影片名，发行年份以及导演。Reviewer ( rID, name )评论者表，属性包括评论者编号，评论者姓名。Rating ( rID, mID, stars, ratingDate )评论表，属性包括评论者编号，影片编号，评分（1-5），评论日期。基于该数据库完成以下SQL题目。要查出所有在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;