Your question is SQL Execution Order. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Explain the order of execution in Tableau when building a view or dashboard.
For the SQL portion, use the supplied PostgreSQL tables to produce the requested result while explaining how the query stages correspond to Tableau's order of operations.
region, account_name, and total_revenue.total_revenue descending, then region and account_name ascending.| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique account identifier |
| account_name | VARCHAR(100) | Account name |
| region | VARCHAR(50) | Account sales region |
| Column | Type | Description |
|---|---|---|
| opportunity_idPK | INT | Unique opportunity identifier |
| account_id | INT | Related account identifier |
| stage | VARCHAR(40) | Opportunity sales stage |
| close_date | DATE | Opportunity close date |
| amount | DECIMAL(12,2) | Opportunity revenue amount |