Question: NEED SQL CODE PLEASE Please use standard aggregate functions, please refrain from using CASE, WHEN, BETWEEN, THEN clauses if possible For each customer , product

NEED SQL CODE PLEASE

Please use standard aggregate functions, please refrain from using CASE, WHEN, BETWEEN, THEN clauses if possible

For each customer, product, month and state combination, compute (1) the customer's average sale of this product for the given month and state, (2) the customer's average sale for the given month and state, but for all other products (3) the customer's average sale for the given product and state, but for all other months and (4) the average sale of the product and the month but for all other states.

Please find attached a sample of the report should look like (SAMPLE ONLY, NOT CORRECT ANSWER)

Report #1: CUSTOMER PRODUCT MONTH STATE CUST AVG OTHER PROD AVG OTHER MONTH AVG OTHER STATE AVG ======== ======= ==: === Helen Bread Emily Milk === 1 NY 3 NJ ====== 243 1426 ==== 1493 926 199 482 ==== 268 478

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!

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

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...

Suppose that R(A, B, C) is a relational schema with functional dependencies F = {A, B C, C B}. (i) Is this schema in 3NF? Explain. [2 marks] (ii) Is this schema in BCNF? Explain. [2 marks] (b)...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

re Regular Languages and Finite Automata (a) Let L be the set of all strings over the alphabet {a, b} that end in a and do not contain the substring bb. Describe a deterministic finite automaton...

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

Risk Assestment Project - Identify 18 Vulnerabilit AICPA Case Development Program Case No. 2000-02: Recreation, Inc. ? 1 RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE STUDY OF...

please help with journal entries. thanks. Required information The following information is taken from the 2015 annual report to shareholders of Hewlett-Packard (HP) CO. For Fiscal 2015 For Fiscal...

4. A cylinder with radius r = 0.75m and length 0.6 m has an infinite line of positive charge along its axis. The charge per unit length is 7 uC/m. (a) Calculate the electric flux through the surface...

A charge of 6 C is moved from a point, the potential at which is 120 V, to another point of potential V. If the energy required to do so is 250 Joule, calculate V.

At Livermore Delivery and Courier Service the following items were found to cause a difference between the bank statement and the firm's records. Indicate whether each item will affect the bank...

John and Ellen Brite (SSN 000-00-1111 and 000-00-2222, respectively) are married and file a joint return. They have no dependents. John owns an unincorporated specialty electrical lighting retail...

Suppose McDonald's 2019 financial statements contain the following selected data (in millions). Current assets..................$ 3,416.3................Interest expense............$ 473.2 Total...

Lewis and Laurie are married and jointly own a home valued at $240,000. They recently paid off the mortgage on their home. In need of cash for personal purposes unrelated to the home, the couple...

The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell...

A firm has total assets of $ 1 0 0 and total debt of $ 2 5 . Equity is $ 7 5 . Debt - equity ratio is 3 . Debt ratios is 2 5 % . Equity ratio is 7 5 % .

Karim Depak received a Form 1099-B showing the following stock transactions and basis during 2012: None of the stock is qualified small business stock. Calculate Karim's net capital gain or loss...

Sally and Charles Heck received the following dividends and interest during 2012: Assuming the Hecks file a joint tax return, complete Schedule B of Form 1040 (on page 2-33) for them for the 2012 tax...

Yolanda is a cash basis taxpayer with the following transactions during the year: Cash received from sales of products........................................................................$65,000...

An investment of $300,000 will yield annual profits of $55,000 for eight years. The proceeds on disposition of the investment at the end of the eight years are estimated at $125,000. On the basis of...

The data from Exercise 3.26 were entered into a MINITAB worksheet, and the following output was obtained. a. Use the MINITAB output or the original data to find the correlation between the number of...

A company is considering two mutually exclusive investment projects. Each requires an initial investment of $25,000. Project A will generate an annual profit of $6000 for eight years and have a...