Table: canadian_championship_players
Columns: season
player
club
nationality
goals

Question: What club did united states player ty harden play for?
SQL: SELECT "club" FROM canadian_championship_players WHERE "nationality" = 'united states' AND "player" = 'ty harden'

Question: Which seaosn had a player of rohan ricketts?
SQL: SELECT COUNT("season") FROM canadian_championship_players WHERE "player" = 'rohan ricketts'