General SQL Query Syntax
SELECT columns to extract
FROM tables containing columns
WHERE search criteria to restrict
rows that are returned
GROUP BY summarizes query results by groups
HAVING search criteria to restrict groups that are returned
ORDER BY sorts results by one or
more columns
- Preceding is the order in which clauses should appear
- Order of processing is as follows: From, Where, Group by, Having, Order by, Select
optional, must be in this order if any or all are used