You have two tables named Customer and SalesOrder. In the Customer table you have 1000 customers, of which 900 customers have orders in the SalesOrder table.
You execute the following query to list all customers that have had at least one sale.
SELECT * FROM Customer WHERE Customer.CustomerID IN (SELECT SalesOrder.CustomerID FROM SalesOrder)
You need to identify the results of the query. Which results will the query return?
A. No rows
B. The 900 rows in the Customer table with matching rows in the SalesOrder table
C. The 1000 rows in the Customer table
D. A warning message
