Question DQ22: Complex query using the same table multiple times in different ways
- Prompt: For customers with a Main Office in West Sussex, give me the name of the customer along with a count of how many orders were shipped to their main address and how many were not
- Category: Data Querying
- Datasets: AdventureWorks
Latest Results
| Tool | Score | Timestamp | Video Recording |
|---|---|---|---|
| unsupervised | 5 | June 28, 2024 - 11:02AM | |
| databricks | 0 | July 4, 2024 - 10:21 AM | |
| ChatGPT | 0 | July 10, 2024 - 11:02 AM |
