Planning Multi-Step Queries

Step 1: Start with a real question

Let’s imagine a common data task: Find departments where the average employee salary is higher than the overall company average.

This question appears to be a single query, but it’s actually several steps in disguise.

Ask yourself:

1. What’s the company's average salary?

2. What’s the average per department?

3. How do I compare them?

Each part can become its own query step, a building block for the final answer. ...