what is the question for the query?
Posted
by Kevinniceguy
on Stack Overflow
See other posts from Stack Overflow
or by Kevinniceguy
Published on 2010-04-11T04:27:34Z
Indexed on
2010/04/11
4:53 UTC
Read the original article
Hit count: 290
Sorry...I mean what question will be for this query?
SELECT SUM(price) FROM Room r, Hotel h
WHERE r.hotelNo = h.hotelNo and hotelName = 'Paris Hilton' and
roomNo NOT IN
(SELECT roomNo FROM Booking b, Hotel h
WHERE (dateFrom <= CURRENT_DATE AND
dateTo >= CURRENT_DATE) AND
b.hotelNo = h.hotelNo AND hotelName = 'Paris Hilton');
© Stack Overflow or respective owner