Courseiva

DA0-002

Full exam simulation

1:30:00
1

Data Acquisition and Preparation

hard

A data analyst is working with a sales table that contains columns: sale_id, product_id, sale_date, and amount. They need to calculate a 7-day moving average of sales amount for each product, ordered by sale_date. Which window function syntax should they use?

0 of 90 answered