Eucloid Data Solutions interview question

Its a window and aggregate functions query And other sql basic to intermediate questions.