Latest version of SQL is 2016.
Naming
- Table in plural
- Column in singular
SQL 96
SELECT <expressions>
FROM <table>
JOIN table
ON <join condition>
WHERE <predicate>
GROUP BY <expressions>
HAVING <predicate>
ORDER BY <expressions>
LIMIT <number of results>