已知影片评论数据库包括如下表结构:Movie ( mID, title, year, director )影片表,属性包括影片编号,影片名,发行年份以及导演。Reviewer ( rID, name )评论者表,属性包括评论者编号,评论者姓名。Rating ( rID, mID, stars, ratingDate )评论表,属性包括评论者编号,影片编号,评分(1-5),评论日期。基于该数据库完成以下SQL题目。如果要找出上映时间在1999年后(包括1999年)并且是Cameron的电影的标题,SQL语句为( )
A.
SELECT title FROM Movie WHERE year >= ‘1999’ and director == ‘Cameron’;
B.
SELECT title FROM Movie WHERE year >= ‘1999’ and director = ‘Cameron’;
C.
SELECT title FROM Movie WHERE year > ‘1999’ and director == ‘Cameron’;
D.
SELECT title FROM Movie WHERE year > ‘1999’ and director = ‘Cameron’;