Database schema

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.

Hint (Click here to expand)
  • Required table(s): PURCHASE_ORDER, PRODUCT, PRODUCT_CODE

You have to make two connections between those tables. You will need GROUP BY and HAVING.