1044.MovieEx-Query reviewer name, movie title, and number of stars

时间限制: 1000 MS    内存限制: 32768 KB
提交: 1    解决: 0

题目描述

For each rating that is the lowest (fewest stars) currently in the database, return the reviewer name, movie title, and number of stars.

 

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