COUNT Column

How can we count employees with a known manager?

Intermediate⏱ 3 Minutes⭐ 750 XP

🤔 THE QUESTION

How can we count employees with a known manager?

💡 WHAT IS IT?

COUNT(column_name) counts only the non-NULL occurrences within the specified column.

🎯 WHAT IS IT USED FOR?

Measuring data completeness, counting assigned accounts, tracking optional field presence.

💻 EXAMPLE

SELECT COUNT(manager_id) AS employees_with_manager
FROM employees;

Practice typing production-grade SQL code for COUNT Column.