COUNT Aggregation

Beginner

The dashboard header shows "N users". Compute N in SQL instead of downloading every row and counting in application code. Some users have not given an email address yet, and they still count as users.

Write a query that returns a single number: how many rows users has.

Constraints

Return a single row with a single column
Count every row, including users whose email is NULL

Hints

Hint 1

COUNT(*) counts rows.

Hint 2

COUNT(column) skips rows where that column is NULL, which would undercount here.

Keywords

SQL

Run your code to see results

No results yet

Run your code to check it against the examples, or submit to run every test.