CREATE TABLE table_name_2 (seasons VARCHAR, coach VARCHAR)

How many seasons did Pat Chambers coach?
SELECT COUNT(seasons) FROM table_name_2 WHERE coach = "pat chambers"
SELECT COUNT("seasons") FROM "table_name_2" WHERE "coach" = "pat chambers"