Table: anti_ship_missile
Columns: name
year
propulsion
launched_by
country

Question: What is the propulsion for the RB 04 earlier than 1962?
SQL: SELECT "propulsion" FROM anti_ship_missile WHERE "year" < 1962 AND "name" = 'rb 04'

Question: What is the name of the anti-ship missile that had a turbojet propulsion that was launched by a surface, sub after 1985?
SQL: SELECT "name" FROM anti_ship_missile WHERE "propulsion" = 'turbojet' AND "year" > 1985 AND "launched_by" = 'surface, sub'

Question: What country had an anti-ship missile that had a solid rocket propulsion?
SQL: SELECT "country" FROM anti_ship_missile WHERE "propulsion" = 'solid rocket'