Guest User

Untitled

a guest
Feb 21st, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. \!h Find an engineer who has also been a producer, for the same amount of time:
  2. SELECT producer_name, years FROM producer WHERE
  3. (producer_name, years) IN -- where prod name and years matches eng name and years
  4. (SELECT engineer_name, years FROM engineer);
  5.  
  6. \!h Equivalent as a join query to compare:
  7. SELECT producer_name, producer.years FROM -- show prod names and years from prod and eng table
  8. producer, engineer WHERE producer_name = engineer_name -- where prod name = eng name
  9. AND producer.years = engineer.years -- and prod years = eng years
Add Comment
Please, Sign In to add comment