user: ### NOW ANSWER:
Question: What is the lowest Round with Overall of 247 and pick less than 41?
Columns: ['Round', 'Pick #', 'Overall', 'Name', 'Position', 'College']
Types: ['real', 'real', 'real', 'text', 'text', 'text']
Sample row: [1.0, 29.0, 29.0, 'R. Jay Soward', 'Wide Receiver', 'USC']
SQL:

assistant: SELECT MIN("Round") FROM "Table" WHERE "Overall" = 247.0 AND "Pick #" < 41.0;