Question: ***Please write queries based on the following requirements*** ***I do not have the Data Set to post, but if you could please provide the SQL

***Please write queries based on the following requirements***

***I do not have the Data Set to post, but if you could please provide the SQL queries for each question, Thank You!***

11. List the average unit price among all the parts. Rename the column as AVG_UNIT_PRICE

12. List the part number and part description for each part with nine characters or ten characters in the part_description. Rank your results in ascending order on part number.

13. Find the item classes and the number of parts under each class. Only show those classes with at least 3 types of parts.

14. List the stored part information for SG parts or parts with more than 60 units stored in warehouse 3.

15. List the number of different part stored in each warehouse, only include those warehouse with at most 3 parts.

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!