This question runs in a pre-configured Salesforce environment - no personal connection required.

Count how many Accounts exist for each unique BillingCountry value. Return a Map where the key is the country name and the value is the count of accounts. Include countries with null or empty billing country as 'Unknown'.

Examples:

Map<String, Integer> distribution = getAccountCountryDistribution();
// Results: {'United States' => 15, 'Canada' => 8, 'Unknown' => 3}

Hints:

  • Use an aggregate SOQL query with GROUP BY to count accounts by country
  • Handle null billing country values in the query or processing
  • Convert AggregateResult objects to a proper Map structure
  • Use the 'Unknown' key for accounts with missing country information
Apex Code Editor
Sign in to Submit

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 account

How 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

Note

You can test your code by connecting to Salesforce, but to save your progress and earn points, you'll need to create an account. Your solutions and achievements will be tracked automatically once you're logged in.