SCHEMA:
CREATE TABLE table_name_74 (against INTEGER, status VARCHAR, opposing_teams VARCHAR)
USER:
What is the average Against, when Status is "2007 Rugby World Cup", and when Opposing Teams is "U.S.A."?

QUERY:
SELECT AVG(against) FROM table_name_74 WHERE status = "2007 rugby world cup" AND opposing_teams = "u.s.a."