Write Queries for the Above ERD, Us schema tables.. a. Write SQL Query and Show total number of customer b. Write SQL Query and Show customer and their order by Customer ID c. Write SQL Query and Show customer with the max amount spend. d. Write SQL Query and Show Top 5 selling products e. Write SQL Query and Show 5 least selling products f. Write SQL Query and Show Top 5 selling and their total amount sold g. Write SQL Query and Show sales by data range h. Write SQL Query and Show sales receipt i. Write SQL Query and Show total sales by data range.

Assignment 2 15420-52019 Picture Format Format Picture SDETAILORDER OD ID CUS ID NUMBER (10) PROO ID NUMBER (10) OPOTY NUMBER 10 OPPRICE NUMBER (10.2) 520190RDER T NUMBER (10) NUMBER C10 ATE NUMBER (10.2 CUS ID Shadow OTOTAL NUMBER(102) FP-CUS_1D-O (0,0) FP PROD ID (PROD ID) Color Soft Edges 3-D Format 3-0 Rotation Astistic Efects 2019CUSTOMER 2019PRODUCTT CUS ID NUMBER (10) VARCHAR2 (Y00 BYTE MNAME VARCHAR2 (100 BYTE VARCHAR2 (100 BYTE ADDRESS VARCHAR2 (100 BYTE NUMBER (10 VARCHAR2 (100 BYTE PROD ID PNAME PDESCRIPTION VARCHAR2 (100 BYTE POTY PPRICE NUMBER() NUMB R (102) ARCHAR2 (100 BYTE CITY STATE CHAR 2 BYTE) NUMBER() VARCHARZ (100 BYTE ARCHAR2 (100 BYTE PROD ID PK (PROD ID) EMAIL PROD_1D-PK (PROD-ID) S2019PRODUCT T PNAME IX(PNAME) CUS ID PK (CUS ID) CUS ID PK(CUS ID) $2019cUSTOMER T LNAME X (LNAME)