question: College of san diego state, and a Pick # smaller than 30 has what lowest overall?
answer: SELECT MIN(overall) FROM table_name_46 WHERE college = "san diego state" AND pick__number < 30
context: CREATE TABLE table_name_46 (overall INTEGER, college VARCHAR, pick__number VARCHAR)