Please use the tables below and develop the SQL to answer the questions. Please provide your SQL in Microsoft Word and submit your document to iCollege.

Table Name: Hotel Table Name: Booking

Inncode Inncode

Brand Booking$\_$date

Address$1$ Channel

Address$2$ 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 $32020.$