Crowdly

It groups employees into categories based on salary

It updates the salary levels of employees

It raises salary for some employees

What does this query output?

SELECT Department, COUNT(*)

FROM Employees

GROUP BY Department

WITH ROLLUP;

Error due to unsupported syntax

Only department counts

Department counts plus a total count of all employees

Total number of departments

Which query returns names of employees who work in the same department as 'Alice'?

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');

ORDER BY AVG(Salary) DESC;

What does this query return?

SELECT Department, AVG(Salary)

FROM Employees

GROUP BY Department

Departments and their total salary

Departments sorted by highest average salary

Error due to missing WHERE clause

Departments ordered by number of employees

Which of the following queries returns the second highest salary?

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);

What will this query do?

SELECT Name

FROM Employees

WHERE ManagerID IS NULL;

Select names of employees without managers

Return an error

Select all managers

Select employees who are managers themselves

What is the role of the alias e in the following query?

SELECT e.Name FROM Employees e WHERE e.Department = 'IT';

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

Which query returns employees who earn more than the average salary?

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);

1. What does this query return?

SELECT Department, COUNT(*)

All departments

Departments with exactly 5 employees

Employees with more than 5 years in a department

Departments with more than 5 employees

Retrieve the current salary of an employee

Which SQL query retrieves the current salary of an employee with emp_no = 20005?

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;