Question

How to convert this relational algebra statement into SQL

(f) 11 pueetName, hotatNo(Booking p king BookinQuetuo Guest) dy Lon(Hl) ote

Answer 1

Answer : this can be converted as : 
(Select guestName, hotelNo From Booking,Guest
Where Booking.guestNo == Guest.guestNo) as B
Where Not Exists (
(Select h.hotelNo From Hotel as h)
Except
( Select * From
(Select hotelNo From Booking,Guest Where
Booking.guestNo == Guest.guestNo) as C
Where B.guestName = C.guestName)
);