Airbnb Superstar Hosts: aggregate listings by host and return hosts with >=3 listings, avg rating >=4.5, and >=90% recent reviews

Shared anonymously from a real Airbnb interview on 2026-05-27. User said they solved everything in time. Prompt: Given ratings records with host_id, listing_id, rating, days_last_review, timestamp, identify Superstar Hosts. A host qualifies if they has at least 3 listings, average rating across all listings is at least 4.5, and at least 90% of reviews across host listings were left within the past 30 days. Return host_id values.