Key Acronyms

SQL = Structured Query Language

QUERY SYNTAX

SELECT <columns> [AS <alias>]
FROM <table>
WHERE <condition> | BETWEEN <value> AND <value> | IN (<valuelist>) | LIKE <expression>
GROUP BY <column> [HAVING <where_condition>]
ORDER BY <columns> [DESC]

Wildcards

% - zero or more characters
_ - single character

Aggregate Functions (for GROUP BY)

AVG()
COUNT()
MAX()
MIN()
SUM()