Find Hosts Meeting Listing, Rating, and Review-Coverage Rules

Identify every host that satisfies a three-part qualification policy for a hosting platform. You are given the following tables: listings listing_id INTEGER PRIMARY KEY host_id INTEGER NOT NULL reviews review_id INTEGER PRIMARY KEY listing_id INTEGER NOT NULL REFERENCES listings.listing_id rating NUMERIC(3,2) NOT NULL, from 1.00 through 5.00 review_date DATE NOT NULL qualification_policy — contains exactly one row as_of_date DATE NOT NULL minimum_average_rating NUMERIC(3,2)…