Database schema

For all products of which there are less than 500 in stock, give their description, their product code and the city and state where this product is produced.

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

You you have to make one connection between those two tables.