slect A.*,B.*,C.*,D.* from room A left join hotel B on A.hotelNo=B.hotelNo left join Booking C on B.hotelNo=C.hotel left join Guest on C.guestNo = D.guestNo where hotelName='Grosvenor Hotel'
SELECT r.roomNo, r.type, r.price, (SELECT g.guestName FROM Guest g, Booking b WHERE g.guestNo = b.guestNo AND b.hotelNo = r.hotelNo AND b.roomNo = r.roomNo) as guestName FROM Room r, Hotel h WHERE r.hotelNo = h.hotelNo AND h.hotelName = 'Grosvenor Hotel'
from room A left join hotel B on A.hotelNo=B.hotelNo left join Booking C on B.hotelNo=C.hotel left join Guest on C.guestNo = D.guestNo
where hotelName='Grosvenor Hotel'
r.type,
r.price,
(SELECT g.guestName FROM Guest g, Booking b WHERE g.guestNo = b.guestNo AND b.hotelNo = r.hotelNo AND b.roomNo = r.roomNo) as guestName
FROM Room r,
Hotel h
WHERE r.hotelNo = h.hotelNo
AND h.hotelName = 'Grosvenor Hotel'