8 lines
282 B
MySQL
8 lines
282 B
MySQL
|
/*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
|
||
|
|
);
|