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

Query the Account object to find all industries that have more than one account with a Rating of "Hot". Return a list of industry names ordered alphabetically. Use aggregate SOQL with GROUP BY and HAVING clauses. Return an empty list if no industries qualify.

Examples:

Input: (no parameters - queries org data) Output: ('Finance', 'Technology') Explanation: Finance and Technology each have more than one Hot account Input: (no industries have multiple hot accounts) Output: () Explanation: Empty list when no industries have more than one Hot account
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

Contest Alert

🏆 All Time Leaderboard

Contest runs January 1, 1970 - December 31, 9999. Complete challenges to climb the leaderboard!

Points are calculated for challenges completed during the contest period.