1040.MovieEx-Query reviewer name, movie title, and number of stars
题目描述
For any rating where the reviewer is the
same as the director of the movie, 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