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 dashboard that shows every agent's experience tier alongside their listing activity and tour volume. Some agents may have no listings or no tours, so the report must handle missing data gracefully using COALESCE.
You are a Brokerage Operations Manager at Compass. Leadership wants a performance dashboard that shows every agent's experience tier alongside their listing activity and tour volume. Some agents may have no listings or no tours, so the report must handle missing data gracefully using COALESCE.