Contacts at Pipeline-Only Accounts

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.

Semi-JoinAnti-JoinRelationship Query

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

40 row(s), order checked

#	Id	Name	Account.Name
1	003000000000020AAA	First 20 Contact 20	Account 1
2	003000000000040AAA	First 40 Contact 40	Account 1
3	003000000000060AAA	First 60 Contact 60	Account 1
4	003000000000080AAA	First 80 Contact 80	Account 1
5	003000000000010AAA	First 10 Contact 10	Account 11
6	003000000000030AAA	First 30 Contact 30	Account 11
7	003000000000050AAA	First 50 Contact 50	Account 11
8	003000000000070AAA	First 70 Contact 70	Account 11
9	003000000000012AAA	First 12 Contact 12	Account 13
10	003000000000032AAA	First 32 Contact 32	Account 13
11	003000000000052AAA	First 52 Contact 52	Account 13
12	003000000000072AAA	First 72 Contact 72	Account 13
13	003000000000014AAA	First 14 Contact 14	Account 15
14	003000000000034AAA	First 34 Contact 34	Account 15
15	003000000000054AAA	First 54 Contact 54	Account 15
16	003000000000074AAA	First 74 Contact 74	Account 15
17	003000000000016AAA	First 16 Contact 16	Account 17
18	003000000000036AAA	First 36 Contact 36	Account 17
19	003000000000056AAA	First 56 Contact 56	Account 17
20	003000000000076AAA	First 76 Contact 76	Account 17
21	003000000000018AAA	First 18 Contact 18	Account 19
22	003000000000038AAA	First 38 Contact 38	Account 19
23	003000000000058AAA	First 58 Contact 58	Account 19
24	003000000000078AAA	First 78 Contact 78	Account 19
25	003000000000002AAA	First 2 Contact 2	Account 3
26	003000000000022AAA	First 22 Contact 22	Account 3
27	003000000000042AAA	First 42 Contact 42	Account 3
28	003000000000062AAA	First 62 Contact 62	Account 3
29	003000000000024AAA	First 24 Contact 24	Account 5
30	003000000000004AAA	First 4 Contact 4	Account 5
31	003000000000044AAA	First 44 Contact 44	Account 5
32	003000000000064AAA	First 64 Contact 64	Account 5
33	003000000000026AAA	First 26 Contact 26	Account 7
34	003000000000046AAA	First 46 Contact 46	Account 7
35	003000000000006AAA	First 6 Contact 6	Account 7
36	003000000000066AAA	First 66 Contact 66	Account 7
37	003000000000028AAA	First 28 Contact 28	Account 9
38	003000000000048AAA	First 48 Contact 48	Account 9
39	003000000000068AAA	First 68 Contact 68	Account 9
40	003000000000008AAA	First 8 Contact 8	Account 9