Show the reviewer and the director's name for the movies with the highest review ratings in...

  

Transcribed Image Text:

Show the reviewer and the director's name for the movies with the highest review ratings in the 1990's order by the reviewer. rev_name Fernando Sharp Flagrant Baronessa Scott LeBrun dir_firstna... dir_lastname Darabont Van Sant Singer Frank Gus Bryan director id INT dir_firstName VAROHAR(30) dir_lastName VARCHAR(30) Indenes movie id INT mov_itle VARCHAR(35) mov year INT mov_time INT mov_lang VARCHAR(15) mov_dt rel DATE mov_re_country VARCHAR(S) gend INT dir_id INT Indexes genre id INT gen_title VARCHAR(10) Indears rating rev_id INT mov_id INT Ⓒrev_rating DECIMAL (6,1) Indeses ō reviewer Fid INT Grev name VARCHAR(45) Indexes Show the reviewer and the director's name for the movies with the highest review ratings in the 1990's order by the reviewer. rev_name Fernando Sharp Flagrant Baronessa Scott LeBrun dir_firstna... dir_lastname Darabont Van Sant Singer Frank Gus Bryan director id INT dir_firstName VAROHAR(30) dir_lastName VARCHAR(30) Indenes movie id INT mov_itle VARCHAR(35) mov year INT mov_time INT mov_lang VARCHAR(15) mov_dt rel DATE mov_re_country VARCHAR(S) gend INT dir_id INT Indexes genre id INT gen_title VARCHAR(10) Indears rating rev_id INT mov_id INT Ⓒrev_rating DECIMAL (6,1) Indeses ō reviewer Fid INT Grev name VARCHAR(45) Indexes

Answer rating: 100% (QA)

To select movies in 1990s ie between 1990 to 1999 we will use this simple qu... View the full answer