12 lines
483 B
MySQL
12 lines
483 B
MySQL
|
/*Write a query to display the employee id, name ( first name and last name ), salary and the SalaryStatus column with a title
|
||
|
|
HIGH and LOW respectively for those employees whose salary is more than and less than the average salary of all employees.
|
||
|
|
|
||
|
|
*/
|
||
|
|
|
||
|
|
SELECT employee_id, first_name, last_name, salary,
|
||
|
|
CASE WHEN salary >=
|
||
|
|
(SELECT AVG(salary)
|
||
|
|
FROM employees) THEN 'HIGH'
|
||
|
|
ELSE 'LOW'
|
||
|
|
END AS SalaryStatus
|
||
|
|
FROM employees;
|