Explain how to compute a 7-day moving average per product. Mention the window frame choice and why.

Problem Statement

Explanation

Partition by product so each series is independent. Order by date so rows stream in time order. Use a ROWS frame of six preceding to current row to capture exactly seven rows, which is stable even with multiple rows per day. RANGE frames can include peers with the same date and change the number of rows. ROWS keeps the window size fixed and matches the business definition precisely.

Code Solution

SolutionRead Only

AVG(amount) OVER (
  PARTITION BY product_id
  ORDER BY sale_date, id
  ROWS BETWEEN 6 PRECEDING AND CURRENT ROW
) AS avg_7d

Practice Sets

This question appears in the following practice sets:

Window Functions & Analytics

Next Question

Master Interviews
Anywhere, Anytime

Explain how to compute a 7-day moving average per product. Mention the window frame choice and why.

Problem Statement

Explanation

Code Solution

Practice Sets

Related Questions

Which SQL statement retrieves all columns and rows from a table named employees?

Which clause filters rows before aggregation and affects which rows are grouped?

What is the default sort order when ORDER BY is used without ASC or DESC?

Which construct is commonly used to paginate results in SQL engines like Postgres and MySQL?

Which predicate correctly checks for missing values in standard SQL?

More from SQL & Databases

Master Interviews Anywhere, Anytime

Explain how to compute a 7-day moving average per product. Mention the window frame choice and why.

Problem Statement

Explanation

Code Solution

Practice Sets

Related Questions

Which SQL statement retrieves all columns and rows from a table named employees?

Which clause filters rows before aggregation and affects which rows are grouped?

What is the default sort order when ORDER BY is used without ASC or DESC?

Which construct is commonly used to paginate results in SQL engines like Postgres and MySQL?

Which predicate correctly checks for missing values in standard SQL?

More from SQL & Databases

Master Interviews
Anywhere, Anytime