This question runs in a pre-configured Salesforce environment - no personal connection required.
Write a method that returns a count of Contacts grouped by Department using SOQL aggregate queries. The method should exclude Contacts with null Department values and return a Map where keys are department names and values are the count of contacts in each department.
Examples:
Map<String, Integer> departmentCounts = countContactsByDepartment();
// Returns: {'Engineering' => 5, 'Sales' => 3, 'Marketing' => 2}
Map<String, Integer> emptyCounts = countContactsByDepartment();
// Returns: {} (if no contacts have departments)
Apex Code Editor
Welcome to Lightning Challenge!
Create an Account
Sign up to track your progress, earn points, and compete with others. Your solutions will be saved automatically.
Create accountHow It Works
- • Write your solution in the code editor
- • Connect your Salesforce org to test
- • Submit to check if your solution passes
- • Use hints if you get stuck
Contest Alert
🏆 #CodeEveryDay May 2026
Contest runs May 1 - 31. Complete challenges to climb the leaderboard!
Only the 31 daily challenges shown during this contest count toward points. Earlier dailies don't carry over.