This question runs in a pre-configured Salesforce environment - no personal connection required.
Write a SOQL query that finds all international accounts (non-US) with annual revenue greater than $10 million. Return account Name, BillingCountry, and AnnualRevenue, ordered by AnnualRevenue in descending order.
Your method should return a List of Account records with only the specified fields populated.
Examples
Input: None (method queries all accounts)
Output: [
Account{Name='Global Tech Solutions', BillingCountry='Germany', AnnualRevenue=75000000},
Account{Name='Innovation Labs', BillingCountry='Japan', AnnualRevenue=65000000},
Account{Name='European Dynamics', BillingCountry='France', AnnualRevenue=45000000}
]
Explanation: Returns non-US accounts with revenue > $10M, sorted by revenue descending
Input: If no international accounts meet criteria
Output: []
Explanation: Returns empty list when no accounts match both conditions
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.