SELECT
  {{column name}}
FROM
  {{table name}}
LIMIT
  {{the number of rows you want back, eg 3}}
ORBER BY
  {{column name you want to use}}
WHERE
  {{conditional logic, eg. price>1.50}}

conditional operators
=
!=
>
>=
<
<=

AND
OR
NOT

example
(price < 100 AND price > 5 OR host='Mel' not price=50)

IN
group values into a list
example, WHERE id IN (20,37)

IS NOT NULL
example. WHERE email IS NOT NULL