Which opposing team had an Against score less than 42 and a Tour Match status in Rugby Park, Gisborne?
CREATE TABLE table_name_48 (opposing_team VARCHAR, venue VARCHAR, against VARCHAR, status VARCHAR)
SELECT opposing_team FROM table_name_48 WHERE against < 42 AND status = "tour match" AND venue = "rugby park, gisborne"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_48 (opposing_team VARCHAR, venue VARCHAR, against VARCHAR, status VARCHAR) Question: Which opposing team had an Against score less than 42 and a Tour Match status in Rugby Park, Gisborne? [/INST] SELECT opposing_team FROM table_name_48 WHERE against < 42 AND status = "tour match" AND venue = "rugby park, gisborne" </s>