CREATE TABLE table_name_97 (player VARCHAR, total VARCHAR, country VARCHAR)

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