Database schema

Provide an overview of the product codes with a total of less than 1000 products in stock. In the resulting table, provide a second column with this number and order the table by this number (from smallest to largest). Use the alias TOTAL for that second column.

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