1
2
3
4
5
6
7
8
9
10
11

INSERT INTO Stay(Patient_id,Room_id,CheckinDate,CheckoutDate)
VALUES(2,3,'2009-01-05','2009-01-17')

INSERT INTO Stay(Patient_id,Room_id,CheckinDate,CheckoutDate)
VALUES(3,3,'2009-01-05','2009-01-17')

INSERT INTO Stay(Patient_id,Room_id,CheckinDate,CheckoutDate)
VALUES(3,3,'2009-01-23','2009-01-27')

INSERT INTO Stay(Patient_id,Room_id,CheckinDate,CheckoutDate)
VALUES(4,3,'2009-02-11','2009-02-14')