CREATE TABLE table_name_12 (total NUMBER, country VARCHAR2, player VARCHAR2)

Which Total has a Country of united states, and a Player of andy north?
SELECT AVG(total) FROM table_name_12 WHERE country = "united states" AND player = "andy north"
SELECT AVG("total") FROM "table_name_12" WHERE "andy north" = "player" AND "country" = "united states"