CREATE TABLE table_name_25 (appearances VARCHAR, team VARCHAR, place VARCHAR)

What is the total number of appearances for players from Chaux-de-Fonds with places over 8?
SELECT COUNT(appearances) FROM table_name_25 WHERE team = "chaux-de-fonds" AND place > 8
SELECT COUNT("appearances") FROM "table_name_25" WHERE "chaux-de-fonds" = "team" AND "place" > 8