OZON.ru Interview Question

Python + SQL interview included a window functions problem and an algorithms problem