How many times does ROY SWEAZY has reserved a room.
CREATE TABLE Reservations (FirstName VARCHAR, LastName VARCHAR)
SELECT COUNT(*) FROM Reservations WHERE FirstName = "ROY" AND LastName = "SWEAZY"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Reservations (FirstName VARCHAR, LastName VARCHAR) Question: How many times does ROY SWEAZY has reserved a room. [/INST] SELECT COUNT(*) FROM Reservations WHERE FirstName = "ROY" AND LastName = "SWEAZY" </s>