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

Calculate the average AnnualRevenue for Accounts that match a given Rating and meet a minimum revenue requirement. Trim the rating input before querying. Return 0 when the rating is missing, the minimum revenue is null, or no accounts satisfy the filter.

Examples:

Decimal avgHot = averageRevenueByRating('Hot', 20000000);
// Results: Average AnnualRevenue for Hot accounts with revenue >= 20,000,000

Decimal avgWarm = averageRevenueByRating(' Warm ', 0);
// Results: Average AnnualRevenue for Warm accounts in the org
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

🏆 #CodeEveryDay Feb 2026

Contest runs February 1 - 28. Complete challenges to climb the leaderboard!

Points are calculated for challenges completed during the contest period.