Show:
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.