Which results will the query return?

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 Customer.CustomerID FROM SalesOrder)

You need to identify the results of the query. Which results will the query return?

A.
No rows

B.
A warning message

C.
The 1000 rows in the Customer table

D.
The 900 rows in the Customer table with matching rows in the SalesOrder table