user: ### NOW ANSWER:
Question: What is arkansas state's total pick number with an overal lower than 242?
Columns: ['Round', 'Pick #', 'Overall', 'Name', 'Position', 'College']
Types: ['real', 'real', 'real', 'text', 'text', 'text']
Sample row: [1.0, 6.0, 6.0, 'Warren Bryant', 'Offensive Tackle', 'Kentucky']
SQL:

assistant: SELECT COUNT("Pick #") FROM "Table" WHERE "College" = 'arkansas state' AND "Overall" < 242.0;