What is the average Against, when Status is "2007 Rugby World Cup", and when Opposing Teams is "U.S.A."?
CREATE TABLE table_name_74 (against INTEGER, status VARCHAR, opposing_teams VARCHAR)
SELECT AVG(against) FROM table_name_74 WHERE status = "2007 rugby world cup" AND opposing_teams = "u.s.a."
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (against INTEGER, status VARCHAR, opposing_teams VARCHAR) Question: What is the average Against, when Status is "2007 Rugby World Cup", and when Opposing Teams is "U.S.A."? [/INST] SELECT AVG(against) FROM table_name_74 WHERE status = "2007 rugby world cup" AND opposing_teams = "u.s.a." </s>