Join me in my syntax of a sales database where I use:
- Date Functions
- Column calculations using operators
- String Manipulations
- Null value handling with 'ISNULL' and 'COALESCE'
- WHERE, ORDER BY, GROUP BY and HAVING clauses with 'BETWEEN', 'IN', 'OR' and 'LIKE' conditions
- JOIN and UNION/UNION ALL
- Aggregate queries (COUNT, SUM, MIN, MAX + AVG)