已知影片评论数据库包括如下表结构: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;
发布时间:2024-05-19 14:35:07