Identify high-quality listings in key cities. Find all listings in San Francisco and New York that have received at least 10 reviews and an average rating of 4.5 or higher. Return listing_id, name, city, the review count, and the average rating rounded to 2 decimal places, ordered by average rating descending.
Schema
listings
listing_idINTEGER
nameVARCHAR
cityVARCHAR
host_idINTEGER
reviews
review_idINTEGER
listing_idINTEGER
ratingDECIMAL
submitted_atDATE
Target output
Target output
| listing_id | name | city | review_count | average_rating |
|---|
| 6 | Chelsea Flat | New York | 10 | 4.90 |
| 1 | Cosy Studio Mission | San Francisco | 10 | 4.70 |
| 4 | Brooklyn Brownstone | New York | 10 | 4.50 |
