Question: Write an SQL query for the following: For each customer, find the busiest date (year, month, day) and slowest date -- i.e., made the most/least

Write an SQL query for the following: For each customer, find the busiest date (year, month, day) and slowest date -- i.e., made the most/least numbers of sales transactions (i.e., maximum/minimum counts of sales transactions, not maximum/minimum quantities)

sales (prod, cust, yr, mo, day, state, quant)

cust busy_yr busy_mo busy_dy slow_yr slow_mo slow_dy

Sam 2020 6 27 2012 12 31

Mia 2017 11 17 2009 3 25

. . . . . . . . . . . . . . . . . . . . .

Emily 2011 9 23 2012 7 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!

Q:

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Q:

Generate 5 separate reports based on the following queries (one report for query #1, one for query #2, one for query #3, one for query #4 and another for query #5): 1. For each customer, compute the...

Q:

this is my assessment which are am going to send you and i need some things about my assessment : Adding some more detail and diving into the case study a bit deeper would really make your points...

Q:

PROJ6000: Principles of Project Management Assessment Assessment 2 - this is actually a case study and its called a Individual Report: PMBoK versus PRINCE2 or Agile in contemporary projects . so one...

Q:

PROJ6000: Principles of Project Management Assessment Assessment 2 - this is actually a case study and its called a Individual Report: PMBoK versus PRINCE2 or Agile in contemporary projects . so one...

Q:

PROJ6000: Principles of Project Management Assessment 3 - Project Charter Report. Length 2,000 words (+/- 10%) Task Summary After reading the project case study, use it to develop a 2,000-word...

Q:

PROJ6000: Principles of Project Management Assessment 3 - Project Charter Report. Length 2,000 words (+/- 10%) Task Summary After reading the project case study, use it to develop a 2,000-word...

Q:

1. Read the case study below. This will form the basis for your Project Charter, because you will assume that you are the project manager for this project. 2. After reading the case study, begin to...

Q:

1. Read the case study below. This will form the basis for your Project Charter, because you will assume that you are the project manager for this project. 2. After reading the case study, begin to...

Q:

1. Read the case study below. This will form the basis for your Project Charter, because you will assume that you are the project manager for this project. 2. After reading the case study, begin to...

Q:

Your company is moving to a new state to take advantage of growth opportunities and attractive tax incentives. You have been asked to work with HR to research the advantages and disadvantages of...

Q:

The nature of the image formed by concave mirror when the object is placed between the focus (F) and centre of curvature (C) of the mirror observed by us is (a) real, inverted and diminished (c)...

Q:

Discuss the reasons that men should wear a suitnot a sport coat and slacksto an interview. Discuss the reasons that women should wear a skirted suit or pantsuitnot sport slacks and a blouseto an...

Q:

An AWM Smart Shelf can help brands and retailers achieve which of the following?

Q:

Are there any questions that you want to ask?

Q:

2. A good source for seeing the subtle differences between legal and illegal job interview questions is at this job Web site: www.jobweb.com/Interview/help .aspx?id=1343&terms=illegal+questions. Use...

Q:

C Do you consider the material you post on various Web sites private? Do you think its ethical for employers to be looking at your postings?