This question runs in a pre-configured Salesforce environment - no personal connection required.

Write a SOQL query that retrieves all child accounts for a given parent account ID. The query should return the child account names and their annual revenue, sorted alphabetically by name.

Examples

Input: parentAccountId = '001XX000003DHPh' Output: [ {'Name': 'Acme Subsidiary A', 'AnnualRevenue': 500000}, {'Name': 'Acme Subsidiary B', 'AnnualRevenue': 750000}, {'Name': 'Acme Subsidiary C', 'AnnualRevenue': 300000} ] Explanation: Returns all accounts where ParentId matches the given ID, sorted by Name Input: parentAccountId = '001XX000003DHPi' Output: [] Explanation: Returns empty list when the parent account has no child accounts Input: parentAccountId = null Output: [] Explanation: Returns empty list for null parent ID
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.