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.

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.