Copy Query and Syntax:

Query: Retrieve records from ITEM column of SALES table where PRICE column having value Less than 100
Syntax: Select ITEM FROM Sales where Price < 100