WHERE
clauseSELECT SUM([Units In Stock]) AS [Units Remaining] FROM Products WHERE (Discontinued = 'True')
SELECT * FROM CustTableThis part of the SELECT statement says to select all columns from the CustTable table.
SELECT * FROM CustTable WHERE ST='AZ'The complete statement. This statement will return all columns from rows where state equals Arizona.