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.

7.List all the order date and the number of orders placed on each date. Rank your results

in descending order on the number of orders.

8.List the warehouse number and the average unit price for warehouses other than

number 2.

9.List the stored part information for SG parts stored in warehouse 2 or 3.

10.List the part number and part description for each part with letter D (or d) in the

part_description. Rank your results in ascending order on item class and then

descending order on units_on_hand.

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.

SELECT FRON ORDER LNE ORDER NUMBER PART NUMBER NUMBER ORDERED 21 05 22.95 4999