Question: Question 2: Consider the following relations between - Provider, Goodies and Stock (See - Schema_All.pdf). Write the following queries in SQL. No duplicates should be

Question 2: Consider the following relations between - Provider, Goodies and Stock (See - Schema_All.pdf). Write the following queries in SQL. No duplicates should be printed in any of the answers. I. Print the names (snames) of the Provider who supply every goodies. II. Print the "pnames" of goodies supplied by only "Acme Widget": III. Print the "sids of provider who supply only red goodies. IV. Print the name of the "provider who only gives the "green parts" and "red parts". V. The provider who gives "green parts" print the provider name and the total number of goodies/parts the provider supplies. VI. For every goodies, print the "sname" of the provider who charges the most for the goodies. Question 2: Consider the following relations between - Provider, Goodies and Stock (See - Schema_All.pdf). Write the following queries in SQL. No duplicates should be printed in any of the answers. I. Print the names (snames) of the Provider who supply every goodies. II. Print the "pnames" of goodies supplied by only "Acme Widget": III. Print the "sids of provider who supply only red goodies. IV. Print the name of the "provider who only gives the "green parts" and "red parts". V. The provider who gives "green parts" print the provider name and the total number of goodies/parts the provider supplies. VI. For every goodies, print the "sname" of the provider who charges the most for the goodies
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
