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!
How It Works
- • Write your solution in the code editor
- • This challenge runs without connecting your own org
- • Submit to check if your solution passes
- • Use hints if you get stuck
Contest Alert
🏆 #CodeEveryDay July 2026
Contest runs July 1 - 31. Complete challenges to climb the leaderboard!
Only the 31 daily challenges shown during this contest count toward points. Earlier dailies don't carry over.