Question d’entretien chez Amazon

Complex SQL query using self join and partition by on a whiteboard