Top Industries by Won Revenue

HardSOQL 50 ptsCreated Oct 9, 2026

Solve the business requirement using SOQL.

Example

Return the matching records or aggregate groups required by the prompt.

Constraints

Use the specified SOQL features and preserve the required ordering.

GROUP BYHAVINGParent Field Aggregate

CodeSOQL

Loading editor…

+3 hidden on submit

visible

Seed data

Account× 20 rows

Name: Account {{i}}Rating: {{pick:Hot|Warm|Cold}}OwnerId: 005000000000001AAAIndustry: {{pick:Technology|Finance|Healthcare|Retail}}AnnualRevenue: {{i*1000000}}

Contact× 80 rows

Email: {{pick:shared@example.com|contact{{i}}@example.com}}Title: {{pick:VP Sales|Chief Executive Officer|Director Sales|Engineer}}LastName: Contact {{i}}AccountId: {{id:Account:i%20+1}}FirstName: First {{i}}CreatedDate: {{datetime:i%30}}

Opportunity× 120 rows

Name: Deal {{i}}IsWon: {{pick:true|false}}Amount: {{i*50000}}OwnerId: 005000000000001AAAIsClosed: {{pick:true|false}}AccountId: {{id:Account:i%20+1}}CloseDate: {{date:-i}}StageName: {{pick:Prospecting|Proposal|Negotiation/Review|Closed Won|Closed Lost}}LeadSource: {{pick:Web|Partner|Referral}}CreatedDate: {{datetime:i%30}}

Case× 60 rows

Status: {{pick:New|Working|Closed}}Subject: Case {{i}}Priority: {{pick:High|Medium|Low}}AccountId: {{id:Account:i%20+1}}CreatedDate: {{datetime:i%30}}

Expected

2 row(s), order checked

#	expr0	Account.Industry
1	91500000	Retail
2	88500000	Finance