How many hotels are there?
select count(*) from hotels
What is the average price range of these hotels?
select avg(price_range) from hotels
How many of hotels have a price above 10000?
select count(*) from hotels where price_range > 10000
Please show the star rating descriptions of these hotels.
select t2.star_rating_description from hotels as t1 join ref_hotel_star_ratings as t2 on t1.star_rating_code = t2.star_rating_code where t1.price_range > 10000