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:
Latest Results
Tool | Score | Timestamp | Video Recording |
---|---|---|---|
cortex | 0 | ||
unsupervised | 0 | ||
databricks | 0 | ||
chatgpt | 5 | ||
tableau | 0 | ||
snowflake | 5 | ||
quicksight | 5 | ||
julius | 5 | ||
bigquery | -5 | ||
genie | 5 |