Advertisement
Guest User

Untitled

a guest
Jun 20th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. select m.title,mhg.genre_id
  2. from movie m , movie_has_genre mhg,genre g
  3. where m.movie_id = mhg.movie_id
  4. and mhg.genre_id = g.genre_id
  5. group by m.title
  6. having count(mhg.genre_id=0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement