The query listed below is producing close to a $1,000$ rows of output. However, there are $600$ rows in Inventory and $600$ rows in Product. What, if anything is wrong with this query.

select productID

$,$ productName

$,$ QuantityOnHand

from product, inventory;

Group of answer choices

The query is missing a group by statement.

There is a cartesian product created by the improper join of product with inventory.

There is nothing wrong with this query.

The query is missing an order by statement.