Table: open_championship_stats_2
Columns: player
country
year_s_won
total
to_par
finish

Question: What player has 1 as the place?
SQL: SELECT "player" FROM open_championship_stats_2 WHERE "finish" = '1'

Question: What country has a total greater than 270, with sandy lyle as the player?
SQL: SELECT "country" FROM open_championship_stats_2 WHERE "total" > 270 AND "player" = 'sandy lyle'

Question: How many totals have t6 as the finish?
SQL: SELECT SUM("total") FROM open_championship_stats_2 WHERE "finish" = 't6'

Question: What player has 289 as the total?
SQL: SELECT "player" FROM open_championship_stats_2 WHERE "total" = 289