This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Brokerage Operations Manager at Compass. Leadership wants a performance leaderboard that ranks agents by how many listings they manage. For each agent, the report should include total listing count, the total value of their sale listings, and the average sale price. The rank should use RANK() so tied agents share the same position.
You are a Brokerage Operations Manager at Compass. Leadership wants a performance leaderboard that ranks agents by how many listings they manage. For each agent, the report should include total listing count, the total value of their sale listings, and the average sale price. The rank should use RANK() so tied agents share the same position.