Pregunta de entrevista de PayPal

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