How many times does ROY SWEAZY has reserved a room.
create table reservations (firstname varchar, lastname varchar, PRIMARY KEY (firstname))
select count(*) from reservations where firstname = "roy" and lastname = "sweazy"