This question runs in a pre-configured Salesforce environment - no personal connection required.
Write a SOQL query that returns Contact names (FirstName + LastName) who have an email address, sorted by LastName in ascending order. If no contacts are found, return an empty list.
The method should query Contacts using the Email field and return formatted names as "FirstName LastName", sorted alphabetically by LastName.
Examples:
Output: ["John Doe", "Jane Smith"]
Explanation: Returns contacts with email addresses, sorted by last name
Input: No contacts with emails exist
Output: []
Explanation: Returns empty list when no contacts have emails
Input: Single contact "Alice Brown" with email
Output: ["Alice Brown"]
Explanation: Returns single formatted name
Input: Multiple contacts with same last name
Output: ["Bob Smith", "Jane Smith"]
Explanation: Both contacts returned, sorted by last name
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.