How many hotels have a price of over 10000?
select count ( * ) from hotels where price_range > 10000
What are the maximum number of stars a hotel with price above 10000 can get?
select max ( star_rating_code ) from hotels where price_range > 10000
Yes. The ones we've been talking about.
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