TIE BREAKER

TIE BREAKER

100

There are 20 employees, but 5 employees have a NULL value in PhoneNumber. 

What is the result?

SELECT COUNT(PhoneNumber)
FROM employees;

15

200

A table contains 100 rows.

What is the result?

SELECT COUNT(*)
FROM table_name
WHERE 1 = 0;

0

300

Which clause executes first?

• ORDER BY
• WHERE
• SELECT
• GROUP BY

WHERE

400

Find the error.

SELECT COUNT(*)
FROM employees
GROUP BY Salary
HAVING Salary > 50000;

No error.

500

What does this return?

SELECT MIN(Salary), MAX(Salary)
FROM employees;

The lowest and highest salary.