(Solved) : Insert Records Room Guest Tables Respectively Follows B Select Rooms Guests Guest Booked R Q31507748 . . . .

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

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

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

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

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

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

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

h)Select all guest numbers