Question: Using SQL queries, provide answers to all 5 questions about Dillard's stores below. Please submit your SQL codes only (10 points each). 1. Calculate the

Using SQL queries, provide answers to all 5 questions about Dillard's stores below. Please submit your SQL codes only (10 points each).

1. Calculate the average transaction dollar amount of items that are sold on January 1st , 2014.

2. Calculate the number of returned items on February 14th, 2014.

3. Calculate the total dollar amount of online sales (Store # 698) between 1/1/2014 and 2/14/2014 (including both dates).

4. Identify the customer number with most frequent purchase transactions between 1/1/2014 and 2/14/2014 (including both dates).

5. Identify the store number with highest number of returns between 1/1/2014 and 2/14/2014 (including both dates)

Hint: For #4 and #5, you may want to use the "Top" command.

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 Accounting Questions!

Q:

Assignment Description: Using SQL queries, provide answers to all 5 questions about Dillard's stores below. Please submit your SQL codes only (10 points each). 1. Calculate the average transaction...

Q:

Using SQL queries, provide answers to all 5 questions about Dillards stores below. Please submit your SQL codes only (10 points each). 1. Calculate the average transaction dollar amount of items that...

Q:

Using SQL queries, provide answers to all 5 questions about Dillard's stores below. Please submit your SQL codes only (10 points each). 1. Calculate the average transaction dollar amount of items...

Q:

Need help with these discussion postings (in a document) and assignments (all in separate files), all directions are included as well. FINANCE DIRECTIONS Need to provide 1 original post substantial...

Q:

As of May 5, 2009, what is Pfizers estimate of the fair value of Wyeths Long-term debt that it will assume? Please provide a dollar amount. PFIZER AND WYETH UNAUDITED PRO FORMA CONDENSED COMBINED...

Q:

Why might the information that Pfizer discloses in the S-4 registration statement not accurately reflect the economic realities of this acquisition? Please list at least three distinct aspects of the...

Q:

As part of consolidation accounting, Pfizer is required to step-up the book value of Wyeths Inventory to fair value by increasing it by $4.6 billion, which Pfizer recognizes on the Pro Forma Combined...

Q:

1) Compute the dollar values that Pfizer estimates for the following items as of May 5, 2009. A) The fair value of Wyeths identifiable net assets. B) The amount of Goodwill that Pfizer expects to...

Q:

Please create an excel spreadsheet with formulas for requirement 5 (pages 24-27)and requirement 6 (pages 28-31)only. Please submit in excel format. Both questions and answers are provided for...

Q:

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Q:

A kangaroo jumped over a fence, because the grass was literally greener on the other side. What was the acceleration of the kangaroo when it was at the highest point on its trajectory, Point C?...

Q:

A company with a WACC of 10.0% is considering a project with the following cash flows: Initial investment = -$475; Years 1-3 = $200. O 2.38 years O 2.42 years O 2.61 years O 1.97 years O 2.26 years

Q:

ABCD is a parallelogram. Show that p + q = r A B D C

Q:

Question 5 Not yet answered Marked out of 1 . 5 0 Flag question The series with correct order of increasing 0 in their complexes is - Select one: a . P R 3 C H 3 - d . P R 3 I - c . C H 3 - d . P R 3...

Q:

=+ d. How would the change you describe in part (c) affect the trade balance in rich nations?

Q:

=+poor nations offered better production effi ciency and legal protections, the trade balance in rich nations such as the United States would move toward surplus. Lets consider why this might be the...

Q:

=+ (a) affect the demand for loanable funds in world fi nancial markets?