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
------- ------
1 Active
2 Active
3 Inactive
4 NULL
B. CustomerId Status
------- ------
1 Active
2 Active
3 Inactive
4 NULL
5 Dormant
6 Dormant
C. CustomerId Status
------- ------
D. CustomerId Status
------- ------
1 Active
2 Active
3 Inactive
