What is the tally with a total larger than 8, Waterford was the opposition?
CREATE TABLE table_name_73 (tally VARCHAR, total VARCHAR, opposition VARCHAR)
SELECT tally FROM table_name_73 WHERE total > 8 AND opposition = "waterford"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_73 (tally VARCHAR, total VARCHAR, opposition VARCHAR) Question: What is the tally with a total larger than 8, Waterford was the opposition? [/INST] SELECT tally FROM table_name_73 WHERE total > 8 AND opposition = "waterford" </s>