PayPal interview question

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