How to evaluate query by DBMS?

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:43 UTC
Read the original article Hit count: 467

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