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
Welcome to Lightning Challenge!
How It Works
- • Write your solution in the code editor
- • This challenge runs without connecting your own org
- • 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.