Guest User

Untitled

a guest
Dec 15th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.15 KB | None | 0 0
  1. SELECT m.title, Count(c.actorid)
  2. FROM casting c JOIN movie m ON
  3. m.id = c.movieid
  4. WHERE m.yr = 1978
  5. GROUP BY m.title
  6. ORDER BY Count(c.actorid) DESC
Add Comment
Please, Sign In to add comment