Force
Challenges
Problems
Daily
Notes
Sign in
Duplicate Contact Emails — SOQL practice problem · ForceChallenges
Problem list
Run
Submit
Run in org
Hardcore
Sign in
to submit
Description
Schema
Hints
Submissions
Solution
Feedback
Duplicate Contact Emails
Hard
SOQL
50 pts
Created Oct 7, 2026
Find email addresses used by more than one contact.
Example
Email
dupes
shared@example.com
2
Constraints
Exclude null emails.
Group by Email and keep counts above 1.
GROUP BY
HAVING
COUNT
Code
SOQL
Loading editor…
Testcases
Test Results
Console Log
My Org
Case 1
+1 hidden on submit
visible
Seed data
Contact
× 12 rows
Email:
shared@example.com
LastName:
Contact {{i}}
Expected
1 row(s), order checked
#
Email
dupes
1
shared@example.com
12