Who is the Opposing Pitcher when Team is phillies, Location is pittsburgh, and Inning is 8th?
CREATE TABLE table_name_37 (opposing_pitcher VARCHAR, inning VARCHAR, team VARCHAR, location VARCHAR)
SELECT opposing_pitcher FROM table_name_37 WHERE team = "phillies" AND location = "pittsburgh" AND inning = "8th"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_37 (opposing_pitcher VARCHAR, inning VARCHAR, team VARCHAR, location VARCHAR) Question: Who is the Opposing Pitcher when Team is phillies, Location is pittsburgh, and Inning is 8th? [/INST] SELECT opposing_pitcher FROM table_name_37 WHERE team = "phillies" AND location = "pittsburgh" AND inning = "8th" </s>