user: ### NOW ANSWER:
Question: What number episode in the series had a production code of 111?
Columns: ['No. in series', 'Title', 'Directed by', 'Written by', 'U.S. viewers (millions)', 'Original U.S. air date', 'Prod. code']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['1–2', '" Big Time Audition "', 'Savage Steve Holland', 'Scott Fellows', '3.5', 'November 28, 2009 August 6, 2010 (Canada)', '101–102']
SQL:

assistant: SELECT "No. in series" FROM "Table" WHERE "Prod. code" = '111';