PostgreSQL

Tenant rental database

1. create table structure
2. create indexes
3. stub some fake data
4. query: list tenants who are renting more than one apartment
5. query: list buildings and the number of open requests

Student grade database

1. create table structure
2. stub some fake data
3. query: list students on the top 10 percentile

Understand explain

1. create table structure
2. explain cases