Guest House Assessment Sample Queries

Show who made the booking for room 101 on 17th Nov 2016

SELECT first_name,last_name
FROM booking JOIN guest ON guest_id = guest.id
 WHERE room_no=101 AND booking_date='2016-11-17'

Show the date of check in and check out and number of nights for booking 5046

SELECT booking_date AS 'check in',
              DATE_ADD(booking_date,INTERVAL nights DAY) AS 'check out',
              nights
FROM booking
 WHERE booking_id=5046