Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. Suppliers(sid:integer,sname:string,address:string)
  2. Parts(pid:integer,pname:string,color:string)
  3. Catalog(sid:integer,pid:integer,cost:real)
  4.  
  5. SELECT S.name, Max(C.cost) FROM Suppliers S
  6. INNER JOIN Catalog C On S.sid = C.sid
  7. INNER JOIN Parts P on P.pid = C.pid
  8. Where P.color = 'RED' OR P.color = 'GREEN'
  9. GROUP BY S.name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement