MYSQL加入一个表并让客人在特定日期之间停留

Question

这是我在架构中给出的问题

List guests with their name and address who have booked a room from “13/01/2016” to “19/01/2016”.

Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

Guest (guestNo, guestName, guestAddress)

请注意每张表中的PK和FK都是斜体

这是我在考试中使用的语法，所以这只是为了实用。

所以我已经使用了这个，我想知道这是否是正确的方法？

SELECT g.guestName, g.guestAddress
FROM Guest g 
    JOIN Booking b ON g.guestNo = b.guestNo
WHERE b.dateFrom DATE(2016-01-13) >=  b.dateTo DATE(2016-01-19)

Answer 1

SELECT g.guestName, g.guestAddress
FROM Guest g 
    JOIN Booking b ON g.guestNo = b.guestNo
WHERE b.dateFrom >=DATE('2016-01-13') AND  b.dateTo <=DATE('2016-01-19')