Amazon SQL Interview Question – Last Person on the Bus
Автор: That Data Nerd
Загружено: 2026-01-15
Просмотров: 1
Описание:
In this video, we solve a medium-level SQL problem from Leetcode where you need to find the last person who could board the bus without exceeding a total weight limit of 1000 kg.
You’ll learn how to:
Use window functions like SUM() OVER (ORDER BY)
Track cumulative totals with running sums
Filter results based on a constraint (like weight threshold)
Pick the last valid record using ORDER BY ... DESC LIMIT 1
Great example of SQL being used in real-time logistics, queues, or capacity planning.
#amazonsql #leetcodesql #sqlinterview #sqlforbeginners
#windowfunctions #sqlchallenge #sqlinterviewquestions
#leetcodemedium #sum #techinterviewprep #amazontag #watchlistbydhruv #thatdatanerd
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
