Which of the following commands will return the number of null values in the member

Databricks Databricks-Certified-Data-Engineer-Associate Question Answer

Which of the following commands will return the number of null values in the member_id column?

SELECT count(member_id) FROM my_table;

SELECT count(member_id) - count_null(member_id) FROM my_table;

SELECT count_if(member_id IS NULL) FROM my_table;

SELECT null(member_id) FROM my_table;

SELECT count_null(member_id) FROM my_table;

Databricks-Certified-Data-Engineer-Associate PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"

Which of the following commands will return the number of null values in the member_id...