What's the Uni# of Timms, who has bats of R?
CREATE TABLE table_name_22 (uni_number VARCHAR, bats VARCHAR, surname VARCHAR)
SELECT uni_number FROM table_name_22 WHERE bats = "r" AND surname = "timms"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_22 (uni_number VARCHAR, bats VARCHAR, surname VARCHAR) Question: What's the Uni# of Timms, who has bats of R? [/INST] SELECT uni_number FROM table_name_22 WHERE bats = "r" AND surname = "timms" </s>