Question II12: Can manage planning aggregations in several tables

• Prompt: Our shipping costs to West Sussex have gone up. Can you tell me which product subcategory IDs and subcategory names we ship to West Sussex the most in terms of total weight (total weight should be the sum of OrderQty * Weight). Return the total weight of each in the results.
• Category:
• Datasets: Adventureworks

Latest Results

Tool	Score	Timestamp	Video Recording
ibm	0		X
databricks	0		X
unsupervised	5		X
julius	5		X
tableau	-5		X
snowflake	0		X
bigquery	0		X
cortex	5		X
qlik	0		X
sap	0		X
genie	5		X
chatgpt	5		X
quicksight	-5		X
spotter	5		X
microstrategy	0		X