Classic Models SQL Solutions

This repository contains solutions for all 82 questions from Richard T. Watson's Classic Models SQL reader:

https://www.richardtwatson.com/open/Reader/ClassicModels.html

Overview

Each .sql file corresponds to a section and contains the original questions followed by their solutions.

The repository covers a broad range of SQL topics, from beginner to advanced, including:

• Filtering and sorting
• Joins
• Aggregate functions and grouping
• One-to-many and many-to-many relationships
• subqueries
• General SQL queries
• Regular expressions
• Spatial data

Files

.
├── correlated_subqueries.sql
├── general_queries.sql
├── many_to_many.sql
├── one_to_many.sql
├── regular_expressions.sql
├── single_entity.sql
└── spatial_data.sql

Notes

• All solutions are written and tested using PostgreSQL.