PayPal Interview Question

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