What is Arkansas State's total pick number with an overal lower than 242?
CREATE TABLE table_33952 (
    "Round" real,
    "Pick #" real,
    "Overall" real,
    "Name" text,
    "Position" text,
    "College" text
)
SELECT COUNT("Pick #") FROM table_33952 WHERE "College" = 'arkansas state' AND "Overall" < '242'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is Arkansas State's total pick number with an overal lower than 242? ### Input: CREATE TABLE table_33952 (
    "Round" real,
    "Pick #" real,
    "Overall" real,
    "Name" text,
    "Position" text,
    "College" text
) ### Response: SELECT COUNT("Pick #") FROM table_33952 WHERE "College" = 'arkansas state' AND "Overall" < '242'