Answer-first summary for fast verification
Answer: SELECT count_if(alternate_email IS NULL) AS missing_alternate_emails FROM customers
To count null values in any column, use the `count_if` function in Databricks SQL. This function specifically counts the number of rows that meet the given condition, in this case, where `alternate_email` is NULL. Learn More: [COUNT_IF() | Databricks SQL](https://docs.databricks.com/sql/language-manual/functions/count_if.html)
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you determine the number of null values in the alternate_email column of an existing Delta table named customers?
A
SELECT count_if(alternate_email IS NULL) AS missing_alternate_emails FROM customers
B
SELECT count(alternate_email IS NULL) AS missing_alternate_emails FROM customers
C
SELECT count_when(alternate_email IS NULL) AS missing_alternate_emails FROM customers
D
SELECT count_where(alternate_email IS NULL) AS missing_alternate_emails FROM customers
E
SELECT count_only(alternate_email IS NULL) AS missing_alternate_emails FROM customers
No comments yet.