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
Get step-by-step solutions from verified subject matter experts
