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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!