CREATE TABLE table_40947 ("Name" CLOB, "Position" CLOB, "Number" FLOAT, "School/Club Team" CLOB, "Season" CLOB, "Acquisition via" CLOB)

Which is the acquisition via that has a school or club team of state?
SELECT "Acquisition via" FROM table_40947 WHERE "School/Club Team" = 'state'
SELECT "Acquisition via" FROM "table_40947" WHERE "School/Club Team" = 'state'