Table: s_8_rocket_stats
Columns: designation
type
length_overall
launch_weight
warhead_weight
range

Question: What is the overall length with a designation of s-8ko?
SQL: SELECT "length_overall" FROM s_8_rocket_stats WHERE "designation" = 's-8ko'

Question: What designation has a launch weight of 11.3kg?
SQL: SELECT "designation" FROM s_8_rocket_stats WHERE "launch_weight" = '11.3kg'

Question: What type has an overall length of 1.605 m?
SQL: SELECT "type" FROM s_8_rocket_stats WHERE "length_overall" = '1.605 m'