user: ### NOW ANSWER:
Question: What was the production code of the episode written by Joe Connelly and Bob Mosher  titled "Beaver Gets Adopted"?
Columns: ['No. in series', 'No. in season', 'Title', 'Directed by', 'Written by', 'Original air date', 'Production code']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text']
Sample row: [41.0, 2.0, '"Eddie\'s Girl"', 'Norman Tokar', 'Joe Connelly and Bob Mosher', 'October9,1958', '955A']
SQL:

assistant: SELECT "Production code" FROM "Table" WHERE "Written by" = 'Joe Connelly and Bob Mosher' AND "Title" = '"Beaver Gets Adopted"';