You have the following rows in the Customer Table:

You write the following query to return all customers that do not have NULL or 'Dormant' for their status:

SELECT * FROM Customer WHERE Status NOT IN (NULL, 'Dormant') You need to identify the results of the query. Which result should you expect?

Question

You have the following rows in the Customer Table:

You write the following query to return all customers that do not have NULL or 'Dormant' for their status:

SELECT * FROM Customer WHERE Status NOT IN (NULL, 'Dormant') You need to identify the results of the query. Which result should you expect?

Accepted Answer

A. Option A

Answer

B. Option B

Answer

C. Option C

Answer

D. Option D

You have the following rows in the Customer Table: You write the following query to return all customers that do not have NULL or 'Dormant' for their status: SELECT * FROM Customer WHERE Status NOT…