Crowdly

SELECT * FROM STAFF WHERE Salary > (SELECT ANY(Salary) FROM STAFF WHERE JOB = 'MGR');

Which query finds employees who earn more than any manager?

SELECT * FROM STAFF WHERE Salary < ANY (SELECT Salary FROM STAFF WHERE JOB = 'MGR');

SELECT * FROM STAFF WHERE Salary > ALL (SELECT Salary FROM STAFF WHERE JOB = 'MGR');

SELECT * FROM STAFF WHERE Salary > ANY (SELECT Salary FROM STAFF WHERE JOB = 'MGR');

SELECT TOP 1 Salary FROM STAFF;

Which query returns the maximum salary from the staff table? (select all that apply)

SELECT MAX(salary) FROM staff;

SELECT TOP 1 Salary FROM STAFF ORDER BY SALARY;

SELECT TOP 1 salary FROM STAFF ORDER BY SALARY DESC;

What is the result of the following query on the staff table? SELECT COUNT(DISTINCT DEPTNUMB) FROM staff;

sql1

Distinct departments (D15, D20, D38, D42)

Distinct employees (Sanders, Pernal, Hanes, etc.)

What does the following query return?

Departments with average salary > 3

Salary of all employees in departments with more than 3 employees.

The average salary for departments with more than 3 employees

The average salary of the top 3 highest-paid employees per department.

SELECT TOP 1 Salary FROM (SELECT DISTINCT TOP 3 Salary FROM STAFF ORDER BY Salary DESC) AS TORDER BY Salary;

What is the result of running the following query?

23000.00

19000.00

17000.00

13540.60

FROM Employees E FULL OUTER JOIN Departments D

What does the following query return?

SELECT E.EMP_ID, E.EMP_NAME, D.DEPT_NAME

ON E.DEPT_ID = D.DEPT_ID;

All employees and departments (excluding nulls)

Employees without departments

Only matching employees and departments

All employees and departments (including nulls)

FROM CUSTOMERS C LEFT JOIN ORDERS O

What does the following query returns?

SELECT C.CUST_ID, C.CUST_NAME, O.ORDER_NUMBER

ON C.CUST_ID = O.CUST_ID

WHERE O.ORDER_NUMBER IS NULL;

Customers with no orders

All customers including the ones with no orders

Only customers who placed orders

Orders with missing customers

What happens when you execute DROP TABLE Employees?

Deletes the table structure but keeps data

Deletes only NULL values

Deletes everything except NULL values

Deletes the table and data

What does the following query do?

ALTER TABLE Employees ADD BirthDate DATE;

Changes the data type of BirthDate

Change the name of the Employees table to BirthDate

Adds a new column BirthDate

Deletes the BirthDate column