-- Database schema
| Ref_Hotel_Star_Ratings : star_rating_code [ TEXT ] primary_key , star_rating_description [ TEXT ] | Locations : Location_ID [ INT ] primary_key , Location_Name [ TEXT ] , Address [ TEXT ] , Other_Details [ TEXT ] | Ref_Attraction_Types : Attraction_Type_Code [ TEXT ] primary_key , Attraction_Type_Description [ TEXT ] | Visitors : Tourist_ID [ INT ] primary_key , Tourist_Details [ TEXT ] | Features : Feature_ID [ INT ] primary_key , Feature_Details [ TEXT ] | Hotels : hotel_id [ INT ] primary_key , star_rating_code [ TEXT ] Hotels.star_rating_code = Ref_Hotel_Star_Ratings.star_rating_code , pets_allowed_yn [ TEXT ] , price_range [ INT ] , other_hotel_details [ TEXT ] | Tourist_Attractions : Tourist_Attraction_ID [ INT ] primary_key , Attraction_Type_Code [ TEXT ] Tourist_Attractions.Attraction_Type_Code = Ref_Attraction_Types.Attraction_Type_Code , Location_ID [ INT ] Tourist_Attractions.Location_ID = Locations.Location_ID , How_to_Get_There [ TEXT ] , Name [ TEXT ] , Description [ TEXT ] , Opening_Hours [ TEXT ] , Other_Details [ TEXT ] | Street_Markets : Market_ID [ INT ] primary_key Street_Markets.Market_ID = Tourist_Attractions.Tourist_Attraction_ID , Market_Details [ TEXT ] | Shops : Shop_ID [ INT ] primary_key Shops.Shop_ID = Tourist_Attractions.Tourist_Attraction_ID , Shop_Details [ TEXT ] | Museums : Museum_ID [ INT ] primary_key Museums.Museum_ID = Tourist_Attractions.Tourist_Attraction_ID , Museum_Details [ TEXT ] | Royal_Family : Royal_Family_ID [ INT ] primary_key Royal_Family.Royal_Family_ID = Tourist_Attractions.Tourist_Attraction_ID , Royal_Family_Details [ TEXT ] | Theme_Parks : Theme_Park_ID [ INT ] primary_key Theme_Parks.Theme_Park_ID = Tourist_Attractions.Tourist_Attraction_ID , Theme_Park_Details [ TEXT ] | Visits : Visit_ID [ INT ] primary_key , Tourist_Attraction_ID [ INT ] Visits.Tourist_Attraction_ID = Tourist_Attractions.Tourist_Attraction_ID , Tourist_ID [ INT ] Visits.Tourist_ID = Visitors.Tourist_ID , Visit_Date [ TEXT ] , Visit_Details [ TEXT ] | Photos : Photo_ID [ INT ] primary_key , Tourist_Attraction_ID [ INT ] Photos.Tourist_Attraction_ID = Tourist_Attractions.Tourist_Attraction_ID , Name [ TEXT ] , Description [ TEXT ] , Filename [ TEXT ] , Other_Details [ TEXT ] | Staff : Staff_ID [ INT ] primary_key , Tourist_Attraction_ID [ INT ] Staff.Tourist_Attraction_ID = Tourist_Attractions.Tourist_Attraction_ID , Name [ TEXT ] , Other_Details [ TEXT ] | Tourist_Attraction_Features : Tourist_Attraction_ID [ INT ] primary_key Tourist_Attraction_Features.Tourist_Attraction_ID = Tourist_Attractions.Tourist_Attraction_ID , Feature_ID [ INT ] Tourist_Attraction_Features.Feature_ID = Features.Feature_ID |
-- -- Show the price ranges of hotels with 5 star ratings.

SELECT price_range FROM HOTELS WHERE star_rating_code  =  "5";