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
Log In
Log in to submit your code and save your progress.

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

Contest Alert

🏆 #CodeEveryDay Contest

Two ways to win a free Salesforce certification voucher:

  • The #1 ranked player on our #CodeEveryDay leaderboard by June 28th
  • Complete challenges to enter our random drawing! Each challenge you complete gives you an additional entry, increasing your chances to win.

Contest runs June 16-28. Additional prizes available for other top leaderboard positions. Track your position and compete for prizes!

Points are only calculated for questions created and completed during the contest period. If you previously won, you are not eligible to win the certification voucher again.