These questions are to be done in Oracle Live SQL The ER diagram has been attached below 1 How much total profit was made for each product sub category Display the total profit and the product sub category by GROUP BY Rename the total profit in the result as TOTAL PROFIT Sort the result by the total profit in descending order 2 Who are the customers with more than five purchases Display their customer IDs, the numbers of purchases, the total sales, and the average sales per purchase by HAVING Rename all fields with new appropriate names Round up numerical values to 3 decimal places ORDERS Order ID Order Date Order Priority Ord ld NUMBER(5) DATE VARCHAR2(20) VARCHAR2(10) PRODUCT Prod id Prod Category Prod Sub Category SHIPPING Ship ID Order ID Ship Mode Ship Date VARCHAR2(20) VARCHAR2(30) VARCHAR2(40) VARCHAR2(10) NUMBER(5) VARCHAR2(20) DATE MARKET Mkt ld Ord ld Prod ld Ship ld Cust ld Sales Discount Order Quantity Profit Shipping Cost Product Base Margin Figure 3 E R Diagram of The Order Database NUMBER(6) VARCHAR2(10) VARCHAR2(20) VARCHAR2(10) VARCHAR2(10) NUMBER(10,5) UMBER(8,2) NUMBER(5) NUMBER(8,2) NUMBER(8,2) NUMBER(8,2)

The Answer is in the image, click to view ...

Question: These questions are to be done in Oracle Live SQL. The ER diagram has been attached below 1. How much total profit was made for

These questions are to be done in Oracle Live SQL. The ER diagram has been attached below

ORDERS Order_ID Order_Date Order_Priority Ord_ld NUMBER(5) DATE VARCHAR2(20) VARCHAR2(10) PRODUCT Prod_id Prod_Category Prod_Sub_Category SHIPPING Ship_ID Order_ID Ship Mode Ship_Date VARCHAR2(20) VARCHAR2(30) VARCHAR2(40) VARCHAR2(10) NUMBER(5) VARCHAR2(20) DATE MARKET Mkt_ld Ord_ld Prod_ld Ship_ld Cust_ld Sales Discount Order Quantity Profit Shipping Cost Product_Base_Margin Figure 3: E/R Diagram of The Order Database NUMBER(6) VARCHAR2(10) VARCHAR2(20) VARCHAR2(10) VARCHAR2(10) NUMBER(10,5) UMBER(8,2) NUMBER(5) NUMBER(8,2) NUMBER(8,2) NUMBER(8,2)

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!

Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Chart Assignment: After reviewing Ch. 10 of aplia in the text, you will put your knowledge to work. You will be constructing charts based on the information below. You must use the information found...

Deliverables: 2 x 500-700 word reflection. Linked learning outcomes: 1. Analyse the environments in which an accountant works 2. Develop personal professional skills and capabilities through the...

PLEASE COMPLETE NO LATER THAN 10/14 @3:30PM Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

i need question uploaded in last picture READING 5.1 The Greed Cycle: How Corporate America Went out of Control JOHN CASSIDY through accounting skulduggery that exag. In this essay, John Cassidy,...

Planning Demand and Supply in a Supply Chain Capacity Planning and Assignment 1 utdallas.edu/~metin Outline Capacity Planning Product-to-plant Assignment utdallas.edu/~metin 2 Deterministic Capacity...

2021_22 5COM1053-61 CS/IT Development Exercise GP3: System Implementation Tasks This document gives details about the tasks you need to complete as a team. The assessment is based on the case study...

Choose a romantic relationship from literature, film or TV to analyze. (You may NOT use characters from a reality show for this assignment.) Using Knapp's relational stages of coming together and...

Use the data in 401KSUBS.RAW for this exercise. (i) Compute the average, standard deviation, minimum, and maximum values of nettfa in the sample. (ii) Test the hypothesis that average nettfa does not...

c. Which company has a lower proportion of debt? Which of these companies exhibits greater risk based on the proportion of debt? Answer 32 has a smaller proportion of total liabilities in its capital...

Breakin Away Company has three employees-a consultant, a computer programmer, and an administrator. The following payroll information is available for each employee: *For hourly employees, overtime...

Reaves Professional Services has three employees?a consultant, a computer programmer, and an administrator. The following payroll information is available for each employee: For the current pay...

A business issued a 90-day note for $80,000 to a creditor on account. The note was discounted at 8%. Journalize the entries to record (a) The issuance of the note and (b) The payment of the note at...

The ledger of Quentin Company contains the following balances: Owners Capital $30,000; Owners Drawings $2,000; Service Revenue $50,000; Salaries and Wages Expense $27,000; and Supplies Expense...

Eric Williams is a cost accountant and business analyst for Diamond Design Company (DDC), which manufactures expensive brass doorknobs. DDC uses two direct-cost categories: direct materials and...

Investors using the buy-and-hold technique can earn profits from an increase in stock value and from

If growth, income, and capital preservation are the primary objectives of mutual funds, why do we bother to categorize funds by type? Do you think such classifications are helpful in the fund...

What are the main investment attractions of put and call options? What are the risks?

Referring to Problem 5.18, assume you have a portfolio with $20,000 invested in each of investments A, B, and C. What is your portfolio beta? In problem Security Beta A .......... 1.4 B .............

Imagining the future, how do you think you might change? How might you stay the same?

What kinds of mistakes do you think parents of the past made? What mistakes do you think todays parents might be making?

What do you think about the idea that, genetically speaking, we are all nearly identical twins?