Question d’entretien chez Amazon

Difference between outer join/inner join, where/having.