typically starting from the "main" entity (CUSTOMER) and joining outward through foreign keys. 3. **Use meaningful aliases** — `c`, `a`, `b`, `t`, `e` map naturally to our five tables. 4. **Comment complex joins:**