user: ### NOW ANSWER:
Question: What is the sum of Overall, when Round is less than 24, and when College is North Carolina State?
Columns: ['Round', 'Pick', 'Overall', 'Name', 'Position', 'College']
Types: ['real', 'real', 'real', 'text', 'text', 'text']
Sample row: [1.0, 7.0, 7.0, 'Larry Isbell', 'RB', 'Baylor']
SQL:

assistant: SELECT SUM("Overall") FROM "Table" WHERE "Round" < 24.0 AND "College" = 'North Carolina State';