CREATE TABLE table_44476 ("Round" FLOAT, "Pick" FLOAT, "Overall" FLOAT, "Name" CLOB, "Position" CLOB, "College" CLOB)

What is the sum of Overall, when Round is less than 24, and when College is North Carolina State?
SELECT SUM("Overall") FROM table_44476 WHERE "Round" < '24' AND "College" = 'north carolina state'
SELECT SUM("Overall") FROM "table_44476" WHERE "College" = 'north carolina state' AND "Round" < '24'