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. Use the alias TOTAL_ORDERED_QUANTITY
for the quantity of products that were ordered.
PURCHASE_ORDER
, PRODUCT
, PRODUCT_CODE
You have to make two connections between those tables. You will need GROUP BY
and HAVING
.