Contacts at Banking Accounts

EasySOQL 10 ptsCreated Oct 2, 2026

Marketing is running a campaign for the Banking vertical.

Return the FirstName, LastName and parent Account.Name of every Contact whose parent Account's Industry is 'Banking'.

Use a child-to-parent relationship query — no subqueries needed.

RelationshipsChild-to-Parent

CodeSOQL

Loading editor…

+1 hidden on submit

30 accounts, 90 contacts

Account× 30 rows

Name: Account {{i}}Industry: {{pick:Technology|Banking|Energy|Retail|Healthcare|Manufacturing}}

Contact× 90 rows

LastName: Person{{i}}AccountId: {{id:Account:i%30+1}}FirstName: {{pick:Ana|Ben|Chen|Dev|Eli}}

15 row(s), any order

#	LastName	FirstName	Account.Name
1	Person1	Ana	Account 2
2	Person7	Ben	Account 8
3	Person13	Chen	Account 14
4	Person19	Dev	Account 20
5	Person25	Eli	Account 26
6	Person31	Ana	Account 2
7	Person37	Ben	Account 8
8	Person43	Chen	Account 14
9	Person49	Dev	Account 20
10	Person55	Eli	Account 26
11	Person61	Ana	Account 2
12	Person67	Ben	Account 8
13	Person73	Chen	Account 14
14	Person79	Dev	Account 20
15	Person85	Eli	Account 26