Question d’entretien chez PayPal

SQL question - employee salary question, case with conditional aggregation.