Question: SQL queries: Write a query that returns a list of unique product departments and the sales, orders, and average order size (i.e. sales/orders) of purchases

SQL queries:

Write a query that returns a list of unique product departments and the sales, orders, and average order size (i.e. sales/orders) of purchases (orderlines) in each department.

products Home InsertPage Layout Formulas D Review View Connections Properties Edit Links Clear From From From New Database Refresh FileMaker HTML Text Sort Filter AdvancedText to Remove D Consolidate What-If Analysis Columns Duplicates Validation A13 1 productproductName 2 200002512 Just FreshDirect Local Organic 2perc Reduced Fat Milk 3 200200418 Red Seedless Grapes 4 200200888 Tommv Atkins Ma 5 20020 6 2002 720021H 8 20030 9 30020 10 30020 11 30070 12 30077 13 4000 G9 14 40060 15 2000 16 3003 orderlD 17 30030 18 40000 19 40000 20 40000 21 300 22 30103 163 productDepartme productDepartment Iry Iry Produce li and Chees orders Home Insert Page Layout Formulas Data Review View Calibri (Body) 12 AA General , $ % , ,00 | +.0| Conditional Format Formatting as Table Paste CustomerID orderlnstance sales units 2 16377154275 155128362 3 16377479625 163684420 4 16377819834 156034258 5 163 6 163 78.18 16.13 2 112.2 16.86 1 43.5 orderlines Insert Page Layout FormulasDataReview View 8 163 9 1637 10 163 11 163 Paste 12 163 13 1637 K4 14 1637 Calibri (Body) A- Av General , 12 24 20000 25 2000 26 20020 27 20020 28 20020 $ ? % , .00 .00 conditional 15 1637 Select 16 1637 1 orderID productID sales units 17 1631 2 16377154275 200002512 7.982 18 1637 3 16377154275 200200418 8.02 2.01 19 1637 4 16377154275 2002008884 20 1637 5 16377154275 200201391 3.5

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!

QUESTION: WRITE EXECUTIVE SUMMARY FOR CUCINA LTD PROJECT 300 WORDS MSC Applied Research Project Cucina Ltd. Competitive advantage through data integrity Company History Cucina Ltd. is an Irish...

MSc Applied Research Project Please answer question (C) Introduction: Section A Fri 31st Jan 2020 Teams should prepare a 10 minute presentation: Venue: Safari Annexe O'Donovan's Road Time:...

Please answer this task: > UNDERSTANDING OF REQUIREMENTS This task is highlighted in red ink on page 10. Overview of each session page. MSc Applied Research Project Cucina Ltd. Competitive advantage...

Please, I am using APEX ORACLE as the platform to write queries . ESPECIALLY QUESTION 9 IS VERY DIFFICULT. Write SQL queries to answer the following questions: 1 . List the total number of customers....

Data Management and Data Analytics . Objective of the project . Base SAS Programming Using SAS Studio on SAS Viya C. SAS Visual Data Mining and machine Learning (In some questions Base SAS...

MSc Applied Research Project PLEASE ANSWER QUESTION 5 (Identification of reports which would benefit Cucina) Teams should prepare a 10 minute presentation: Wed 29th Jan 2020 1. Group identity and...

Ames Writing Instruments Inc. Introduction Ames Writing Instruments (AWI) produces and sells a variety of writing instruments to retail outlets such as drug stores, grocery stores, and office supply...

QUESTION: Begin by preparing your SWOT analysis to get a core understanding of where Amazon and Walmart were as companies in 2017. AMAZON AND WALMART ON COLLISION COURSE (CASE A) AMAZON AND WALMART...

1. Brief Introduction of the Storeking and its business models. 2. SWOT analysis 3. Which were the main issues / challenges that Storeking had? 4. Considering the issues, you could find, please...

Multi-User Database Systems Case Study A database is to be constructed for the Hatfield Apple Tree Suppliers (HATS). HATS sells a wide variety of apple trees of differing varieties. The plants are of...

Pick your favorite restaurant. Analyze its current brand strategy and make one recommendation for changing or strengthening the existing brand strategy. From the case study, determine which video...

Write a paper about Ingvar Kamprad and the IKEA Company 1. Describe the nature of followership that kamprad seems to have encouraged at ikea. 2. Using the leadership grid and its underlying leader...

The Water Works Company is considering a $ 1 3 5 , 0 0 0 investment in either of two companies. The cash flows are as follows: \ table [ [ Year , Reading Raitway,B 6 0 Raitway ] , [ 1 , $ 8 5 , 8 8 8...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

KEY QUESTION Suppose a tax is such that an individual with an income of $10,000 pays $2000 of tax, a person with an income of $20,000 pays $3000 of tax, a person with an income of $30,000 pays $4000...

KEY QUESTION Explain the following statement, using the MB curve in Figure 28.6 to illustrate: The optimal amount of pollution abatement for some substances, say, water from storm drains, is very...

KEY QUESTION Suppose there are only five people in a society and each favors one of the five highway construction options in Table 28.2 (include no highway construction as one of the options)....