Count the Rank-Final which has a Year larger than 2008, and an Apparatus of balance beam, and a Rank-Qualifying larger than 4?
CREATE TABLE "competitive_history" (
  "year" real,
  "competition_description" text,
  "location" text,
  "apparatus" text,
  "rank_final" real,
  "score_final" real,
  "rank_qualifying" real,
  "score_qualifying" real
);
SELECT COUNT("rank_final") FROM "competitive_history" WHERE "year">2008 AND "apparatus"='balance beam' AND "rank_qualifying">4;