What is the total number of appearances for players from Chaux-de-Fonds with places over 8?
CREATE TABLE "top_goal_scorers" (
  "place" real,
  "scorer" text,
  "goals" real,
  "appearances" real,
  "team" text
);
SELECT COUNT("appearances") FROM "top_goal_scorers" WHERE "team"='chaux-de-fonds' AND "place">8;