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

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

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

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

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

schemas provided need help with sql codes for these - Questions 1- Calculate the average transaction dollar amount of items that are sold on January 1", 2014 2- Calculate the number of returned items...

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

Practice Section You may want to download and open the Practice Database in Lesson 4 in Microsoft Access (Admissions Student Database.mdb; Please note that this database is graciously provided...

Prepare a Statement of Advice (SOA) for the Martins interviewed for Assignment 1. The case study information is attached as a picture at the bottom of the page. As this assignment is to be a SOA for...

Im having trouble with question 3 part A of the attached file. I know and understand her needs but im not sure if im filling out the table correctly ? Assignment Tier 1 Financial Planning...

i need help from section 3 part A I have already posted this and you asked me to post under advanced option Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student...

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

A company has the following balances on December 31, 2024, before any year-end adjustments: Accounts Receivable = $80,000; Allowance for Uncollectible Accounts = $1,100 (credit). The company...

Use pattern tests to determine if the sample observations in Problem 3-5 reflect any nonrandom patterns.

Under the variable interest entity consolidation method, a company must own at least 5 0 % of an investment in order to consolidate the investment

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...