Interview pack
Window functions deep-dive
The window-function questions in the bank, back to back — ranking, running totals, LAG/LEAD and NTILE, the topic that trips up the most candidates.
hardRunning total of daily salesShopee · windowFree→hardPrevious month's revenueGrab · windowFree→hardSecond most expensive product per categoryLazada · windowFree→hardRank customers by spendMaybank · windowBasic→hardRank customers by transaction amount, per branchHSBC · windowBasic→hardDrivers delayed 3+ days in a rowNinja Van · windowBasic→hardMonth-over-month change in units soldSony · windowBasic→hardDay-over-day change in order volumeGrabFood · windowBasic→hardSplit customers into spending quartilesShopee · windowBasic→hardBusiest data center in each regionAlibaba · windowBasic→
Company names are trademarks of their respective owners, used here only to describe practice material. mahir_data is not affiliated with, endorsed by, or sponsored by any company named on this site. Terms.