Ask a difficult SQL query statement

Basic information on all hotels in a certain city: select * from hotel table where HotelCity='city name'

The lowest and highest price of each hotel room: select min(HousePrice ) lowest price, max(HousePrice) highest price from price list where HotelCity='city name' group by HotelName

lowest price in hotels in this city select min(HousePrice) lowest price from price list where HotelCity= 'City name' and HotelName='Hotel name'