Table schema:
CREATE TABLE table_name_97 (player VARCHAR, total VARCHAR, country VARCHAR)

Question: What player has a 147 total from Spain?
SQL: SELECT player FROM table_name_97 WHERE total = 147 AND country = "spain"