Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Suppliers(sid:integer,sname:string,address:string)
- Parts(pid:integer,pname:string,color:string)
- Catalog(sid:integer,pid:integer,cost:real)
- SELECT S.name, Max(C.cost) FROM Suppliers S
- INNER JOIN Catalog C On S.sid = C.sid
- INNER JOIN Parts P on P.pid = C.pid
- Where P.color = 'RED' OR P.color = 'GREEN'
- GROUP BY S.name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement