This question runs in a pre-configured Salesforce environment - no personal connection required.
Write a SOQL query that returns Account Names from a given country, sorted by Name in ascending order. If the country parameter is null or empty, or if no accounts are found, return an empty list.
The method should query accounts using the BillingCountry field and sort the results alphabetically by Name.
Examples:
Input: country = "USA"
Output: ["Account A", "Account B", "Account C"]
Explanation: Returns all account names from USA, sorted alphabetically
Input: country = "Germany"
Output: ["German Account"]
Explanation: Returns the single account from Germany
Input: country = null
Output: []
Explanation: Returns empty list for null country
Input: country = ""
Output: []
Explanation: Returns empty list for empty country
Input: country = "NonExistentCountry"
Output: []
Explanation: Returns empty list when no accounts match
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
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.