You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
/*Write a query to display the employee id, employee name (first name and last name ) for all employees who earn more than the
|
|
average salary.*/
|
|
SELECT employee_id, first_name,last_name
|
|
FROM employees
|
|
WHERE salary >
|
|
( SELECT AVG(salary)
|
|
FROM employees
|
|
); |