
Asked in Tech Mahindra
What is the SQL query to calculate the average sales over a period of 7 days?

AnswerBot
6mo
Calculate average sales over a 7-day period using SQL query.
Use the AVG() function to calculate the average sales.
Filter the data based on the date range of the 7-day period using WHERE clause.
Group t...read more
Help your peers!
Add answer anonymously...
Top Data Engineer Interview Questions Asked at Tech Mahindra
Q. What are Spark optimization techniques?
Q. Write an SQL query to calculate the running total of sales_amount, grouped by de...read more
Q. How do you create an external table?
Interview Questions Asked to Data Engineer at Other Companies
Top Skill-Based Questions for Tech Mahindra Data Engineer
Big Data Interview Questions and Answers
250 Questions
SQL Interview Questions and Answers
250 Questions
Cloud Computing Interview Questions and Answers
250 Questions
Data Structures Interview Questions and Answers
250 Questions
Python Interview Questions and Answers
200 Questions
Spark Interview Questions and Answers
50 Questions
Stay ahead in your career. Get AmbitionBox app


Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app

