Advanced PostgreSQL: A Fast-Paced Revision Guide

TL;DR: this post is not meant for beginners. if you have basic understanding of SQL then this post is understandable to you One schema (acme), one dataset, every pattern below runs as-is on PostgreSQL