Open Pipeline Rollup by Owner and Stage — SOQL practice problem · ForceChallenges

HardcoreSign in to submit

Open Pipeline Rollup by Owner and Stage

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 BY ROLLUPAggregates

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

7 row(s), any order

#	cnt	total	OwnerId	StageName
1	60	183000000	null	null
2	12	36600000	005000000000001AAA	Prospecting
3	12	39000000	005000000000001AAA	Closed Lost
4	12	35400000	005000000000001AAA	Closed Won
5	12	37800000	005000000000001AAA	Negotiation/Review
6	12	34200000	005000000000001AAA	Proposal
7	60	183000000	005000000000001AAA	null