Please use the tables below and develop the SQL to answer the questions

Table Name: Hotel		Table Name: Booking
Inncode		Inncode
Brand		Booking_date
Address1		Channel
Address2		Roomnights
City		Revenue
State		Confirmation_Nbr
Zip
Country

The first digit of the confirmation number represents group (9), individual (1-5) and key accounts (8) bookings. For example: the first digit of the confirmation number for group bookings is 9. Please provide all the group bookings for HOLI hotels in Rome GA United States, New York NY United States and HIEX hotels in London, United Kingdom. The reservations need to be made by the GDS channel in Quarter 3 2020.

Use:

Select (What columns above?)

From (What Tables above?)

Where