This repository contains SQL queries and database testing examples using the Pagila database (PostgreSQL sample DB).
The goal was to practice SQL querying and validate data integrity using real-world-like database structure.
Included Files:
- 30 queries Contains 30 SQL queries covering:
- SELECT statements
- JOINs
- Aggregations
- Filtering and sorting
- Data analysis scenarios
- Query Results (CSV). Each query has a corresponding result file (e.g. query_01_first_10_customers.csv)
- Google Sheets. All results combined in one file.