CREATE TABLE table_204_291 (id NUMBER, "rank" NUMBER, "name" CLOB, "nation" CLOB, "cp" NUMBER, "fp" NUMBER, "points" NUMBER, "placings" NUMBER)

name a competitor that scored more that 2600 points and was from canada .
SELECT "name" FROM table_204_291 WHERE "points" > 2600 AND "nation" = 'canada'
SELECT "name" FROM "table_204_291" WHERE "nation" = 'canada' AND "points" > 2600