This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Product Analyst at Redfin. The operations team needs a tour activity report that shows which agent conducted each tour and which property it was for. Since tours reference listings (not properties directly), you need to chain through the listings table to reach the property address. Build a report joining tours, agents, listings, and properties.
You are a Product Analyst at Redfin. The operations team needs a tour activity report that shows which agent conducted each tour and which property it was for. Since tours reference listings (not properties directly), you need to chain through the listings table to reach the property address. Build a report joining tours, agents, listings, and properties.