SHARE
TWEET

Untitled

a guest Jan 16th, 2019 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. query #3:
  2.  
  3. select a.fname, a.lname
  4. from actor a, casts c, movie m
  5. where a.id = c.pid AND
  6. c.mid = m.id AND
  7. (m.year < 1900 OR m.year > 2000)
  8.  
  9. query #5
  10.  
  11. select a.fname, a.lname, m.name, COUNT(DISTINCT c.role) AS roles
  12. from actor a, movie m, casts c
  13. where a.id = c.pid AND
  14. c.mid = m.id
  15. group by a.fname, a.lname, m.name
  16. having roles >= 5;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top