Which Record has an Opponent of pittsburgh pirates, and a Date of may 5?
CREATE TABLE table_name_79 (record VARCHAR, opponent VARCHAR, date VARCHAR)
SELECT record FROM table_name_79 WHERE opponent = "pittsburgh pirates" AND date = "may 5"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_79 (record VARCHAR, opponent VARCHAR, date VARCHAR) Question: Which Record has an Opponent of pittsburgh pirates, and a Date of may 5? [/INST] SELECT record FROM table_name_79 WHERE opponent = "pittsburgh pirates" AND date = "may 5" </s>