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.
*
, DESCRIPTION
, QUANTITY_ON_HAND
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
.