It removes employees with low salary

It groups employees into categories based on salary

It updates the salary levels of employees

It raises salary for some employees

Error due to unsupported syntax

Only department counts

Department counts plus a total count of all employees

Total number of departments

SELECT Name FROM Employees WHERE Department = (SELECT Department FROM Employees);

SELECT Name FROM Employees WHERE Name != 'Alice' AND Department = (SELECT Department FROM Employees WHERE Name = 'Alice');

SELECT Name FROM Employees WHERE Department = ALL (SELECT Department FROM Employees WHERE Name = 'Alice');

SELECT Name FROM Employees WHERE Department = (SELECT Department FROM Employees WHERE Name = 'Alice');

Departments and their total salary

Departments sorted by highest average salary

Error due to missing WHERE clause

Departments ordered by number of employees

SELECT TOP 2 Salary FROM Employees ORDER BY Salary DESC;

SELECT MAX(Salary) FROM Employees WHERE Salary < (SELECT MAX(Salary) FROM Employees);

SELECT Salary FROM Employees ORDER BY Salary DESC LIMIT 2;

SELECT MAX(Salary) FROM (SELECT Salary FROM Employees ORDER BY Salary DESC LIMIT 2);

Select names of employees without managers

Return an error

Select all managers

Select employees who are managers themselves

It is a table alias used to simplify references

It filters out duplicate rows

It prevents errors in case of missing column names

It is used to rename the table permanently

SELECT * FROM Employees HAVING Salary > AVG(Salary);

SELECT * FROM Employees WHERE AVG(Salary) < Salary;

SELECT * FROM Employees WHERE Salary > AVG(Salary);

SELECT * FROM Employees WHERE Salary > (SELECT AVG(Salary) FROM Employees);

All departments

Departments with exactly 5 employees

Employees with more than 5 years in a department

Departments with more than 5 employees

SELECT salary FROM salaries WHERE emp_no = 20005 AND to_date = '9999-01-01';

SELECT salary FROM employees WHERE emp_no = 20005;

SELECT salary FROM salaries WHERE emp_no = 20005;

SELECT salary FROM dept_emp WHERE emp_no = 20005;