Accounts With Only Lost Deals

HardSOQL 50 ptsCreated Oct 9, 2026

Solve the business requirement using SOQL.

Return the requested records or aggregate groups, preserving the required filters and ordering.

Use the SOQL features named in the tags. Return the required fields and ordering.

Semi-JoinAnti-JoinClosed Lost

CodeSOQL

Loading editor…

+3 hidden on submit

visible

Account× 4 rows

Name: Account {{i}}

Opportunity× 8 rows

Name: Lost Deal {{i}}IsWon: falseAmount: {{i*100000}}IsClosed: trueAccountId: {{id:Account:i%4+1}}CloseDate: {{date:-i}}StageName: Closed Lost

4 row(s), any order