Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write Queries for the Above ERD, Us schema tables..e. Write SQL Query and Show 5 least selling products f. Write SQL Query and Show Top
Write Queries for the Above ERD, Us schema tables..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) 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)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started