Ex 9.3 screenshot # 4

38 ® SELECT rev_name, mov_title, mov_year, mov_rel country, rev_rating 39 FROM rating 40 INNER JOIN movie ON rating.mov_id = movie.id 41 INNER JOIN reviewer ON rating.rev_id = reviewer.id 42 - WHERE mov_rel_country = (SELECT mov_rel_country 43 FROM movie 44 GROUP BY mov_rel_country 45 ORDER BY COUNT(*) DESC 46 LIMIT 1)| esult Grid ‘ HH 4% Fiter Rows: I | Export: Ef ‘ Wrap Cell Content: A rev_name mov_title mov_year mov_rel_country rev_rating Paul Monks Vertigo 1958 UK 5.9 Mike Salvati Vertigo 1958 UK 6.3 Sasha Goldshtein Vertigo 1958 UK 6.0 Krug Stillo Vertigo 1958 UK 6.5 Vincent Cadena Vertigo 1958 UK 9.1 Richard Adams Vertigo 1958 UK 6.2 Bonita Daly Vertigo 1958 UK 8.7 Miranda Hatfield Vertigo 1958 UK 9.0 Righty Sock Lawrence of Arabia 1962 UK 8.9 Jack Malvern Lawrence of Arabia 1962 UK 5.9 Alec Shaw Lawrence of Arabia 1962 UK 9.6 Victor Woeltjen Lawrence of Arabia 1962 UK 4.1 Paul Monks Lawrence of Arabia 1962 UK 9.8 Mike Salvati Lawrence of Arabia 1962 UK 7.1 Lawrence of Arabia 1962 UK 8.1 Josh Cates Lawrence of Arabia 1962 UK 3.0 Bonita Daly Lawrence of Arabia 1962 UK 10.0 wvie 162 movie 163 movie 164 Result 165 Result 166 Result 167 Result 168 X