1050.MovieEx-Query director's name, title and stars

时间限制: 1000 MS    内存限制: 32768 KB
提交: 159    解决: 39

题目描述

For each director, return the director's name together with the title(s) of the movie(s) they directed that received the highest rating(stars) among all of their movies, and the value of that rating. Ignore movies whose director is NULL.

 

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