CREATE TABLE table_47224 ("Player" CLOB, "Nationality" CLOB, "Jersey Number ( s ) " CLOB, "Position" CLOB, "Years" CLOB, "From" CLOB)

What years were from Connecticut?
SELECT "Years" FROM table_47224 WHERE "From" = 'connecticut'
SELECT "Years" FROM "table_47224" WHERE "From" = 'connecticut'