Question d’entretien chez Amazon

SQL window function and different types of joins