Myntra Interview Question

Question were from SQL (Joins, window functions)