human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Round, Pick #, Overall, Name, Position, College
###Question: What is the lowest Round with Overall of 247 and pick less than 41?
gpt
SELECT MIN Round FROM table WHERE Overall = 247 AND Pick # < 41