SQL Syntax - SELECT

• SELECT
• [FROM table_references ]
• [WHERE where_condition]
• [GROUP BY {col_name | expr | position} [ASC | DESC]]
• [HAVING where_condition]
• [ORDER BY {col_name | expr | position} [ASC | DESC]]

Here is a SELECT statement with all of its level 2 arguments shown

You Must have a FROM Argument, but the rest are optional

Where is the Data coming FROM

Only return a part of the data WHERE this condition is true

GROUP the data based on this criteria

Another way to limit the data returned

Sort the data by using the ORDER Argument