Moving Average Sales Of 7 Days Window SQL Problem Solution#sqlinterviewquestions

--Restaurant Growth 7 Days Sales Average Problem Description –
You are the restaurant owner and you want to analyze a possible expansion (there will be at least one customer every day).
--Write an SQL query to compute the moving average of how much the customer paid in a seven days window
--(i.e., current day + 6 days before)
--Return result table ordered by visited_on in ascending order.

#sql
#interview #tableau #
#tableaudeveloper
#tableaudeveloperintreviewquestion

#sql
#interview #tableau #
#tableaudeveloper
#tableaudeveloperintreviewquestion
#sql #question #intreview
#SQLINTREVIEWQUESTION
#SQLquestionsfordataanalyst
#sqlfordataanalysts
#sqlquestionfordataanalysts
#sqlinterview
#sqlinterviewquestionsandanswers,
#sqlquestionsandanswers
#sqlinterviewdataanalyst
#sqltechnicalinterviewquestions
#sqltechnicalquestions
#sqlinterviewquestions
#sql
#dataanalystjob
#dataanalystCareer
#dataanalyst,
#howTobecomeadataanalyst
#dataandanalytics
#businessanalytics
#businessintelligenceanalyst

[ArabindaMohapatra]

SQL Script----

If you learn something
Please do like & subscribe to my channel