Database schema

List all info about all products that contain the word Monitor or Speaker in their description and of which there are less than 400 in stock (QUANTITY_ON_HAND). Order these products (alphabetical) by their description.

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

If the word can appear anywhere in a piece of text, put the % wildcard before and after it. If you don't write parentheses, the AND takes precedence over the OR.