A sаles mаnаger needs the fоllоwing query: SELECT sale_date, amоunt, AVG(amount) OVER (ORDER BY sale_date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS moving_avg FROM daily_sales; What does the moving_avg column show? OPTIONS:A. The overall average of all sales in the tableB. The average of sales for the current day onlyC. The average sales for the current day and the two prior daysD. The average sales for the current day and the two following days ANSWER:C EXPLANATION:The window frame includes the current row and the two preceding rows, so the moving average is calculated across 3 days.