Which Surname has Bats of r, and a Position of p, and a DOB of 20 may 1989?
CREATE TABLE table_name_73 (surname VARCHAR, dob VARCHAR, bats VARCHAR, position VARCHAR)
SELECT surname FROM table_name_73 WHERE bats = "r" AND position = "p" AND dob = "20 may 1989"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_73 (surname VARCHAR, dob VARCHAR, bats VARCHAR, position VARCHAR) Question: Which Surname has Bats of r, and a Position of p, and a DOB of 20 may 1989? [/INST] SELECT surname FROM table_name_73 WHERE bats = "r" AND position = "p" AND dob = "20 may 1989" </s>