This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Business Intelligence Analyst at Realtor.com. The customer success team wants to understand inquiry patterns — who is reaching out, about which property, through what channel, and how fast agents respond. Some inquiries have no recorded response time, and for reporting purposes those should appear as -1 instead of NULL. Build a report that joins inquiries to users and the listing's property details.
You are a Business Intelligence Analyst at Realtor.com. The customer success team wants to understand inquiry patterns — who is reaching out, about which property, through what channel, and how fast agents respond. Some inquiries have no recorded response time, and for reporting purposes those should appear as -1 instead of NULL. Build a report that joins inquiries to users and the listing's property details.