Large-Deal Lead Source Analysis

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.

COUNT_DISTINCTAVGHAVING

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

3 row(s), order checked

#	accts	deals	avgAmt	LeadSource
1	10	20	3100000	Partner
2	10	19	3050000	Web
3	10	20	3000000	Referral