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...
Tech Mahindra Data Engineer interview questions & answers
A Data Engineer was asked 2mo agoQ. What are Spark optimization techniques?
A Data Engineer was asked 2mo agoQ. Write an SQL query to calculate the running total of sales_amount, grouped by de...read more
A Data Engineer was asked 4mo agoQ. How do you create an external table?
Popular interview questions of Data Engineer
A Data Engineer was asked 2mo agoQ1. What are Spark optimization techniques?
A Data Engineer was asked 2mo agoQ2. Write an SQL query to calculate the running total of sales_amount, grouped by de...read more
A Data Engineer was asked 4mo agoQ3. How do you create an external table?
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
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.
Follow Us
