How many Losses have an NTFA Div 2 of perth, and Wins smaller than 10?
CREATE TABLE "2009_ladder" (
  "ntfa_div_2" text,
  "wins" real,
  "byes" real,
  "losses" real,
  "draws" real,
  "against" real
);
SELECT COUNT("losses") FROM "2009_ladder" WHERE "ntfa_div_2"='perth' AND "wins"<10;