CREATE TABLE table_name_98 (club_team VARCHAR, player VARCHAR)

What was the club team for Kyle de Coste?
SELECT club_team FROM table_name_98 WHERE player = "kyle de coste"
SELECT "club_team" FROM "table_name_98" WHERE "kyle de coste" = "player"