Question: Write SQL codes for these requirements based off of the five tables below. I have attached five pictures of the five tables there are with
Write SQL codes for these requirements based off of the five tables below. I have attached five pictures of the five tables there are with what each of them contain.
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
