Reference schema: the tables and sample data used by every query below.

Answer preview

Every query in this section runs against the same small PostgreSQL schema — an HR side (departments, employees), an e-commerce side (customers, products, orders, order_items), and a few puzzle tables (logins, seats, accounts, bookings, salary_staging). Read it once here so the re…