Clauses

 SELECT

WHERE

GROUP BY

HAVING

DISTINCT

GROUPING SETS

ORDER BY Clause

ORDER BY ASC/DESC

AND

OR 

AS 

WITH

IN

BETWEEN 

ANY

LIKE