#window

Calculate cumulative sales for each product in each store, ordered by sale_date

Compute the moving average of daily transactions over a 7-day window.

Describe your approach to managing data deduplication.

Fetch the rows with the highest scores for each student in a year.

Given exchange rates for USD to INR with timestamps: Find the ticket price in rupees for various dates. Use the latest exchange rate based on the timestamp for each date.

Given the data with id, name, and department, how would you calculate how many employees are in each department?

How would you monitor and reduce disk-based queries (disk spilling)?

Identify the top 5 customers with the highest purchases in the last quarter.