Question: 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

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!

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

1. Write an SQL query to show the top 10 best-selling products by total Qty (i.e., quantity). 2. Write an SQL query to show the total gross sales revenues each department makes by selling each brand....

I need some assistance with my project proposal and its overview, my systems analysis and entity-relation diagram(ERD) and overall database creation. I am using Microsoft Visio and MS SQL 2012 as...

I need help making the SQL statements in visual studio 2017 Please read homework carefully svxGS0201 9 1 0/Project%20Task%2075628 1 %29.pdf MGMT 329: Database Management Project Task 7: Requi The...

This assessment addresses the following course outcomes: Differentiate between database systems and file systems by comparing features and functions to determine benefits in data management Analyze...

URGENT - PLEASE PROVIDE RESPONSE IN ORDER OR MENTION WHICH ONE HAS BEEN ANSWERED .THANK YOU ! Scenario BooksRUs is a local bookstore that started in 1978 in a small New England town. BooksRUs has...

CIS 205 Final Project Summer 2018 The final assignment consists of separating a database project into the phases that were outline during the semester. The project should be completed with the...

PLEASE HELP ! Need serious help with this Final Milestone- failing class- Thank you ! Scenario BooksRUs is a local bookstore that started in 1978 in a small New England town. BooksRUs has been able...

You will develop an E-Commerce database used to maintain customers, products and sales information. You are required to 1) gather and analyze requirements 2) design logical structure of the database...

a . Draw its dependency diagram and identify all dependencies, including all partial and transitive dependencies.b . Remove all partial dependencies, and draw the new dependency diagrams. Identify...

How does the use of the materials requisition help control the issuance of materials from the storeroom? Discuss in detail.

Suppose that X can take the values 0, 1, 2, 3, and 4, and the probability distribution of X is incompletely specified by the function Find (a) f(4) (b) P[X > 2] (c) E(X) and (d) sd(X). 1(3 (s) for0,,...

Julia's Cookies has identified the following cash receipt control activity risk: "Cash discounts taken by customers that are incorrect may result in loss of profit and future cash receipts." Choose...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

The company openly shares plans and information with employees.

You serve on the professional development committee of a national association in your field.Your group recently sponsored a regional seminar on a pertinent topic in that field. The all-day seminar,...

You are an intern for the Eagleton Eagles, a minor league baseball team. Your supervisor, Matt Marks, has asked you to analyze the following data about the entertainment offered before games,between...