ForceChallenges

Accounts Without Opportunities — SOQL practice problem · ForceChallenges

HardcoreSign in to submit

Accounts Without Opportunities

MediumSOQL 25 ptsCreated Oct 2, 2026

Find white-space for the sales team: return the Id and Name of every Account that has no Opportunities at all.

Constraints

Return exactly Id and Name.
Row order is not checked.

Semi-joinAnti-join

CodeSOQL

Loading editor…

+1 hidden on submit

40 accounts, opps on half

Seed data

Account× 40 rows

Name: Prospect {{i}}

Opportunity× 60 rows

Name: Deal {{i}}AccountId: {{id:Account:(i%20)*2+1}}CloseDate: {{date:i}}StageName: Prospecting

Expected

20 row(s), any order

#	Id	Name
1	001000000000002AAA	Prospect 2
2	001000000000004AAA	Prospect 4
3	001000000000006AAA	Prospect 6
4	001000000000008AAA	Prospect 8
5	001000000000010AAA	Prospect 10
6	001000000000012AAA	Prospect 12
7	001000000000014AAA	Prospect 14
8	001000000000016AAA	Prospect 16
9	001000000000018AAA	Prospect 18
10	001000000000020AAA	Prospect 20
11	001000000000022AAA	Prospect 22
12	001000000000024AAA	Prospect 24
13	001000000000026AAA	Prospect 26
14	001000000000028AAA	Prospect 28
15	001000000000030AAA	Prospect 30
16	001000000000032AAA	Prospect 32
17	001000000000034AAA	Prospect 34
18	001000000000036AAA	Prospect 36
19	001000000000038AAA	Prospect 38
20	001000000000040AAA	Prospect 40