Amazon interview question

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