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
Find the reservations made by a person called ROY SWEAZ
assistant
SELECT * FROM Reservations WHERE FirstName = 'ROY' AND LastName = 'SWEAZY' ;
human
How many kids stay in the rooms reserved by this person?
assistant
SELECT kids FROM Reservations WHERE FirstName = "ROY" AND LastName = "SWEAZY" ;