Question d’entretien chez Amazon

Deep dive on current project? SQL - Highest salary, basic joins, window functions.