1. How does SELECT COUNT(phone) differ from SELECT COUNT(*) in a table of 100 rows where 20 phone values are NULL?
- COUNT(phone) returns 80, while COUNT(*) returns 100.
- COUNT(phone) returns 100, while COUNT(*) returns 80.
- Both return 80.
- COUNT(phone) throws an error.
Hint: COUNT(*) counts every row in the partition. COUNT(column) ignores rows where the specified column is NULL.