Domanda di colloquio di Amazon

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