Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedWrite 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 23rd European Conference Adbis 2019 Bled Slovenia September 8 11 2019 Proceedings Lncs 11695

Authors: Tatjana Welzer ,Johann Eder ,Vili Podgorelec ,Aida Kamisalic Latific

1st Edition

3030287297, 978-3030287290

More Books

Students also viewed these Databases questions

Question

Explain the causes of indiscipline.

Answered: 1 week ago

Question

Explain the factors influencing wage and salary administration.

Answered: 1 week ago

Question

The company openly shares plans and information with employees.

Answered: 1 week ago