It updates the salary levels of employees

It groups employees into categories based on salary

It raises salary for some employees

 It removes employees with low salary

Total number of departments

Only department counts

Department counts plus a total count of all employees

Error due to unsupported syntax

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

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

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

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

Error due to missing WHERE clause

Departments and their total salary

Departments ordered by number of employees

Departments sorted by highest average salary

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

SELECT TOP 2 Salary FROM Employees ORDER BY Salary DESC;

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

SELECT Salary FROM Employees ORDER BY Salary DESC LIMIT 2;

Return an error

Select employees who are managers themselves

Select all managers

Select names of employees without managers

It is used to rename the table permanently

It is a table alias used to simplify references

It filters out duplicate rows

It prevents errors in case of missing column names

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

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

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

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

Departments with more than 5 employees

All departments

Departments with exactly 5 employees

Employees with more than 5 years in a department

SELECT title FROM titles WHERE emp_no = 30001;

SELECT title FROM titles WHERE emp_no = 30001 AND to_date = '9999-01-01';

SELECT title FROM salaries WHERE emp_no = 30001;

SELECT title FROM employees WHERE emp_no = 30001;