please tell which method is used ie jion etc

a) Consider the following database schema (the Expedia database): Locations (Zipcoder City, State) Hotels HotelID, Name, Lipcode, NumRooms) Searches Searchip, Zipcode, startDate, Duration, NumPeople) Results HotelId, searchID, Rank, Price) Hotels.Zipcode is a foreign key referring to Locations.Zipcode. Results.HotelID is a foreign key referring to Hotels HotelID. Searches.Zipcode is a foreign key referring to Locations.Zipcode. Results SearchID is a foreig key referring to Searches. SearchID. > Write a single SQL to answer the following: Get the names and cities of the top hotels (in increasing order of their rank) for the search request with SearchID 564 such that all the hotels output are in the same state as the state corresponding to the zipcode from the given search request