Provide an overview of the description of the product codes of which more than 500 products have been ordered. Also show how many products have been ordered.
PURCHASE_ORDER
, PRODUCT
, PRODUCT_CODE
You have to make two connections between those tables. You will need GROUP BY
and HAVING
.