SQL

Many of the example queries in this page refer to:

• Pagila Database

Pagila Schema

Image Source

---

Table of contents

• SQL Query Basics
• SQL Joins
• SQL Grouping
• SQL CTE
• SQL Window Function
• SQL Advanced Aggregation
• DDL
• Hierarchical Query