Advertisement
androsov

Untitled

Sep 20th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.28 KB | None | 0 0
  1. SELECT
  2.     movie.primaryTitle, rating.rating
  3. FROM `title.rating` rating
  4. INNER JOIN `title.basics` movie ON rating.titleId=movie.titleId
  5. INNER JOIN `title.principal` people ON people.personId='nm0000704' AND people.titleId=movie.titleId
  6. ORDER BY rating.rating DESC
  7. LIMIT 100;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement