Myntra interview question

Advance SQL based questions like window functions, joins etc