Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How can you determine the number of null values in the alternate_email column of an existing Delta table named customers?
alternate_email
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
