How many times does ROY SWEAZY has reserved a room.
CREATE TABLE rooms (
    roomid text,
    roomname text,
    beds number,
    bedtype text,
    maxoccupancy number,
    baseprice number,
    decor text
)

CREATE TABLE reservations (
    code number,
    room text,
    checkin text,
    checkout text,
    rate number,
    lastname text,
    firstname text,
    adults number,
    kids number
)
SELECT COUNT(*) FROM reservations WHERE firstname = "ROY" AND lastname = "SWEAZY"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many times does ROY SWEAZY has reserved a room. ### Input: CREATE TABLE rooms (
    roomid text,
    roomname text,
    beds number,
    bedtype text,
    maxoccupancy number,
    baseprice number,
    decor text
)

CREATE TABLE reservations (
    code number,
    room text,
    checkin text,
    checkout text,
    rate number,
    lastname text,
    firstname text,
    adults number,
    kids number
) ### Response: SELECT COUNT(*) FROM reservations WHERE firstname = "ROY" AND lastname = "SWEAZY"