Pagila SQL

A collection of 60+ SQL queries built on the Pagila database.

Overview

This repository contains SQL queries that demonstrate and reinforce core SQL concepts, including:

• Data retrieval (SELECT)
• Filtering and sorting
• Joins
• Aggregate functions
• Subqueries
• Window functions
• Common Table Expressions (CTEs)

Prerequisites

• PostgreSQL
• The Pagila sample database installed and loaded into your PostgreSQL instance