Calculate cumulative sales for each product in each store, ordered by sale_date
General/Othermedium
2
Compute the moving average of daily transactions over a 7-day window.
General/Othermedium
3
Describe your approach to managing data deduplication.
General/Othermedium
4
Fetch the rows with the highest scores for each student in a year.
General/Othermedium
5
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.
General/Othermedium
6
Given the data with id, name, and department, how would you calculate how many employees are in each department?
General/Othermedium
7
How would you monitor and reduce disk-based queries (disk spilling)?
System Design/Architecturemedium
8
Identify the top 5 customers with the highest purchases in the last quarter.
General/Othermedium
+20 More Questions with Expert Answers
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.