Problem Statement

Find every employee whose salary is strictly greater than the company-wide average salary. Use a scalar subquery in the WHERE clause. Return employee_id, first_name, last_name, salary — ordered by salary DESC, employee_id.

Relevant Tables