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
Sign in to Submit

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

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.