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!
Select
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?
Data Engineer Interview Questions
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
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

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.

Follow Us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter
Profile Image
Hello, Guest
AmbitionBox Employee Choice Awards 2025
Winners announced!
awards-icon
Contribute to help millions!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos
Add office benefits
Add office benefits