CREATE TABLE table_name_12 (total INTEGER, country VARCHAR(255), player VARCHAR(255))
Which Total has a Country of united states, and a Player of andy north?
    
SQL: SELECT AVG(total) FROM table_name_12 WHERE country = "united states" AND player = "andy north"