Whats the SQL needed for 3) Which hotel costs which airline the most money?

CREATE TABLE Airline( Airlineld INT NOT NULL PRIMARY KEY IDENTITY Name VARCHAR (50) NOT NULL, ContactId INT NOT NULL FOREIGN KEY REFERENCES Person(PersonId), Abbreviation VARCHAR (10) NOT NULL CountryId INT NOT NULL FOREIGN KEY REFERENCES Country(CountryId), MonthlyRent MONEY NOT NULL CREATE TABLE HotelAffiliate( HotelAffiliateId INT NOT NULL PRIMARY KEY IDENTITY, AirlineId INT NOT NULL FOREIGN KEY REFERENCES Airline(AirlineId), HotelId INT NOT NULL FOREIGN KEY REFERENCES Hotel (HotelId) CREATE TABLE Hotel( HotelId INT NOT NULL PRIMARY KEY IDENTITY, HotelName VARCHAR (40) NOT NULL, HotelAddress VARCHAR (60) NOT NULL NumberOfRooms INT NOT NULL Price MONEY NOT NULL CREATE TABLE Airline( Airlineld INT NOT NULL PRIMARY KEY IDENTITY Name VARCHAR (50) NOT NULL, ContactId INT NOT NULL FOREIGN KEY REFERENCES Person(PersonId), Abbreviation VARCHAR (10) NOT NULL CountryId INT NOT NULL FOREIGN KEY REFERENCES Country(CountryId), MonthlyRent MONEY NOT NULL CREATE TABLE HotelAffiliate( HotelAffiliateId INT NOT NULL PRIMARY KEY IDENTITY, AirlineId INT NOT NULL FOREIGN KEY REFERENCES Airline(AirlineId), HotelId INT NOT NULL FOREIGN KEY REFERENCES Hotel (HotelId) CREATE TABLE Hotel( HotelId INT NOT NULL PRIMARY KEY IDENTITY, HotelName VARCHAR (40) NOT NULL, HotelAddress VARCHAR (60) NOT NULL NumberOfRooms INT NOT NULL Price MONEY NOT NULL