Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL queries on following Tables SUPPLIERS,PARTS, SUPPLIER_PART Please Help me out in these queries. 1) Get supplier names for suppliers who supply the parts. Blue
SQL queries on following Tables SUPPLIERS,PARTS, SUPPLIER_PART
Please Help me out in these queries.
1) Get supplier names for suppliers who supply the parts. Blue Parts.
2) Get all pairs of supplier numbers who reside in the same city.
3) Get supplier names for suppliers who do not supply part p2.
4) Get supplier names for suppliers who supply all parts.
s (Supplier) SNAME Smith S2 Jones S3 Blake S4 Clark S5 Adams P Part PNAME PI Nut Bolt P2 P3 Screw P4 Screw P5 Cam P6 Cog SP 300 P2 200 400 P4, 200 PS 100 100 S2 Pu 300 P2 400 P2 200 P2 200 S4 P4 300 400 STATUS 20 30 20 30 COLOR Red Green Blue Red Blue Red CITY London Paris Paris London Athens WEIGHT CITY 12.0 17.00 17.0 14.0 12.0 19.00 London Paris Rome London Paris LondonStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started