human
Schema:
Rooms (RoomId, roomName, beds, bedType, maxOccupancy, basePrice, decor)
Reservations (Code, Room, CheckIn, CheckOut, Rate, LastName, FirstName, Adults, Kids)
Please answer with SQL.
assistant
Sure, I understand.
human
Which reservations were made by DAMIEN TRACHSEL?
assistant
SELECT * FROM Reservations WHERE FirstName = 'DAMIEN' AND LastName = 'TRACHSEL' ;
human
Which one has check in date Sep 21, 2010?
assistant
SELECT * FROM Reservations WHERE CheckIn = '2010-09-21' AND FirstName = 'DAMIEN' AND LastName = 'TRACHSEL' ;
human
Find the number of kids for this reservation.
assistant
SELECT Kids FROM Reservations WHERE CheckIn = "2010-09-21" AND FirstName = "DAMIEN" AND LastName = "TRACHSEL" ;