Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT act.fname, act.name, COUNT(cha.CHARACTER), mov.title
- FROM h_o.CHARACTER cha, h_o.CAST cas, h_o.movie mov, h_o.actors act
- WHERE cha.cid = cas.cid
- AND act.aid=cas.aid
- AND mov.mid=cas.pid
- GROUP BY act.fname, act.name, mov.title
- HAVING COUNT(cha.CHARACTER) > 1
- ORDER BY COUNT(cha.CHARACTER) DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement