Table: k_166_submarine
Columns: col
shipyard
laid_down
launched
commissioned
fleet
status

Question: When were the ships launched that were laid down on september 1, 1964?
SQL: SELECT "launched" FROM k_166_submarine WHERE "laid_down" = 'September 1, 1964'

Question: List the # for ships commissioned on december 18, 1965.
SQL: SELECT "col" FROM k_166_submarine WHERE "commissioned" = 'December 18, 1965'

Question: List the # for ships commissioned on september 30, 1967.
SQL: SELECT "col" FROM k_166_submarine WHERE "commissioned" = 'September 30, 1967'

Question: When were ships laid down that were commissioned on october 29, 1965?
SQL: SELECT "laid_down" FROM k_166_submarine WHERE "commissioned" = 'October 29, 1965'