Common SQL Commands: A Living Document

This document is intended to serve as a resource for some commonly used SQL commands. Examples can be found in the Jupyter notebook. For instance, the document includes:

• SELECT
• WHERE
• ORDER BY
• GROUP BY
• JOIN
• INSERT INTO
• UPDATE
• DELETE
• CREATE TABLE
• DROP TABLE
• CASE WHEN
• DISTINCT
• LEFT JOIN
• OUTER JOIN
• UNION
• SUM and COUNT
• Date-time Manipulation
• String Formatting and Substrings
• Window Function and RANK()
• Subqueries
• HAVING vs WHERE
• LAG and LEAD
• Indexing
• Running Totals
• MAX and MIN