This question runs in a pre-configured Salesforce environment - no personal connection required.
Write a SOQL query that returns a Map where the key is the country name and the value is the total number of accounts in that country. Only include countries that have at least one account.
Examples:
Input: Database with accounts from various countries
Output: Map<String, Integer> where key=Country, value=account count
Explanation: Returns country names with their respective account counts
Input: No accounts in database
Output: Empty map
Explanation: No countries meet the criteria
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
Two ways to win a free Salesforce certification voucher:
- The #1 ranked player on our #CodeEveryDay leaderboard by June 28th
- Complete challenges to enter our random drawing! Each challenge you complete gives you an additional entry, increasing your chances to win.
Contest runs June 16-28. Additional prizes available for other top leaderboard positions. Track your position and compete for prizes!
Points are only calculated for questions created and completed during the contest period. If you previously won, you are not eligible to win the certification voucher again.