Question DQ29: Complex query using window function
- Prompt: For each customer, calculate the proportion of their "Max Devices" compared to the overall max "Max Devices" across all customers. Give me Customer IDs which have the largest proportion?
- Category:
- Datasets: Telco
Latest Results
| Tool | Score | Timestamp | Video Recording |
|---|---|---|---|
| cortex | 5 | ||
| unsupervised | -5 | ||
| databricks | 0 | ||
| chatgpt | 5 | ||
| tableau | 5 | ||
| snowflake | 5 | ||
| quicksight | 5 | ||
| julius | 5 | ||
| bigquery | 5 | ||
| genie | 0 | ||
| qlik | 0 | ||
| sap | 0 | ||
| ibm | 0 | ||
| spotter | -5 | ||
| microstrategy | 0 |