View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.
Evaluate the following SQL statement:
Which statement is true regarding the above compound query?
A.
It produces an error.
B.
It shows products that were sold and have a cost recorded.
C.
It shows products that were sold but have no cost recorded.
D.
It shows products that have a cost recorded irrespective of sales.