You have the following rows in the
Customer Table:
CustomerId Status
1 Active
2 Active
3 Inactive
4 NULL
5 Dormant
6 Dormant

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?

A.
CustomerId Status

B.
CustomerId Status
1 Active
2 Active
3 Inactive

C.
CustomerId Status
1 Active
2 Active
3 Inactive
4 NULL

D.
CustomerId Status
1 Active
2 Active
3 Inactive
4 NULL
5 Dormant
6 Dormant