High-Value Tech Contacts with Account Owner — SOQL practice problem · ForceChallenges

HardcoreSign in to submit

High-Value Tech Contacts with Account Owner

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.

Parent RelationshipsMulti-Level TraversalNULLS LAST

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

8 row(s), order checked

#	Id	Name	Account.Name	Account.Owner.Name
1	003000000000016AAA	First 16 Contact 16	Account 17	Ada Admin
2	003000000000056AAA	First 56 Contact 56	Account 17	Ada Admin
3	003000000000036AAA	First 36 Contact 36	Account 17	Ada Admin
4	003000000000076AAA	First 76 Contact 76	Account 17	Ada Admin
5	003000000000052AAA	First 52 Contact 52	Account 13	Ada Admin
6	003000000000032AAA	First 32 Contact 32	Account 13	Ada Admin
7	003000000000012AAA	First 12 Contact 12	Account 13	Ada Admin
8	003000000000072AAA	First 72 Contact 72	Account 13	Ada Admin