CREATE TABLE table_name_47 (games VARCHAR2, club VARCHAR2)

What games have colomiers as the club?
SELECT games FROM table_name_47 WHERE club = "colomiers"
SELECT "games" FROM "table_name_47" WHERE "club" = "colomiers"