CREATE TABLE table_name_56 (seasons VARCHAR2, name VARCHAR2)

How many seasons did Charles C. Farrell coach?
SELECT COUNT(seasons) FROM table_name_56 WHERE name = "charles c. farrell"
SELECT COUNT("seasons") FROM "table_name_56" WHERE "charles c. farrell" = "name"