This question runs in a pre-configured Salesforce environment - no personal connection required.
Write a SOQL query to find accounts that are Customer accounts with an annual revenue greater than 1 million. Return the account ID, name, type, and annual revenue, ordered by annual revenue descending.
Examples:
Input: Database contains accounts with various types and revenue levels
Output: List of accounts with Id, Name, Type, AnnualRevenue where Type = 'Customer' and AnnualRevenue > 1000000, ordered by AnnualRevenue DESC
Explanation: Query returns customer accounts with high revenue in descending order
Input: No customer accounts meet the revenue criteria
Output: Empty list
Explanation: No customer accounts found with annual revenue above 1 million
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 Feb 2026
Contest runs February 1 - 28. Complete challenges to climb the leaderboard!
Points are calculated for challenges completed during the contest period.