How many kids stay in the rooms reserved by ROY SWEAZY?
create table reservations (kids varchar, firstname varchar, lastname varchar, PRIMARY KEY (kids))
select kids from reservations where firstname = "roy" and lastname = "sweazy"