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.
 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

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!