COUNT

How can we count the number of employees?

Intermediate⏱ 3 Minutes⭐ 740 XP

🤔 THE QUESTION

How can we count the number of employees?

💡 WHAT IS IT?

COUNT(*) computes the total number of rows matching the query criteria, including rows with NULL values.

🎯 WHAT IS IT USED FOR?

Record counting, volume estimation, data sanity checks, total employee rosters.

💻 EXAMPLE

SELECT COUNT(*) AS employee_count
FROM employees;

Practice typing production-grade SQL code for COUNT.