I want the standing for january 29 and finished of 3rd and total points less than 248
CREATE TABLE "2011_supercross_results" (
  "round" real,
  "date" text,
  "place" text,
  "finished" text,
  "total_points" real,
  "standing" text
);
SELECT "standing" FROM "2011_supercross_results" WHERE "total_points"<248 AND "finished"='3rd' AND "date"='january 29';