What is the result of COUNT(*) on a table with 5 rows where 2 rows have NULL in a column?

Question

SQL Data Analyst — Easy

What is the result of COUNT(*) on a table with 5 rows where 2 rows have NULL in a column?

Accepted Answer

When using COUNT(*) on a table, it counts all rows, including those with NULL values. In this case, there are 5 rows in total, so the result of COUNT(*) will be 5.