1031.Movie-Find all years that have a movie that received a rating of 4 or 5

时间限制: 1000 MS    内存限制: 32768 KB
提交: 14    解决: 4

题目描述

Find all years(year) that have a movie that received a rating of 4 or 5, and sort them in increasing order.

 

You can find the full data description here

movie ( mID, title, year, director )

English: There is a movie with ID number mID, a title, a release year, and a director.

mID

title

year

director

int

varchar

int

varchar

101

Gone with the Wind

1939

Victor Fleming

102

Star Wars

1977

George Lucas

 

reviewer ( rID, name )

English: The reviewer with ID number rID has a certain name.

rID

name

int

varchar

201

Sarah Martinez

202

Daniel Lewis

 

rating ( rID, mID, stars, ratingDate )

English: The reviewer rID gave the movie mID a number of stars rating (1-5) on a certain ratingDate.

rID

mID

stars

ratingDate

int

int

int

date

201

101

2

2011-01-22

 

来源

Unknown