a)Again, insert some records into the room and the guest tables respectively as follows:

b)Select all rooms and guests such that the guest has booked the room (using where clause).

c)Select all rooms and guests such that the guest has booked the room (using join clause).

d)Select all rooms and guests such that the guest has booked the room (using variables).

e)Select all room prices booked by James Bond (using where clause).

f)Select all room prices booked by James Bond (using join clause).

g)Select all room prices booked by James Bond (using variables).

h)Select all guest numbers and names in the hotel Hilton. If we use the following statement

Select guestNo, guestName From room, guest

Where room.guestNo=guest.guestNo And hotelName=Hilton;

What will happen? Why? What is the correct statement?

i)Select all rooms booked by male with the price over 500 and ordered by prices, but only show the room number and hotel name.

j)Select the average price of rooms booked by someone, group by gender.

k)Select the overall price of rooms booked by the same person.

l)Count the number of rooms as number of rooms booked by James Bond.

m)Select the guest names that need to pay more than 500.

n)Select those guests who have booked at least two rooms.

New Query Options Results Hessages lhotelio standard standard