Table: naval_warships_2
Columns: warship
tons_l_ton
horse_power
speed_knots
main_artillery
built_year

Question: How man horse power did the ship covadonga have?
SQL: SELECT "horse_power" FROM naval_warships_2 WHERE "warship" = 'Covadonga'

Question: What is the primary artillery for the  1,051 ships?
SQL: SELECT "main_artillery" FROM naval_warships_2 WHERE "tons_l_ton" = '1,051'

Question: List the maximum speed for the 1.150 ton ships?
SQL: SELECT "speed_knots" FROM naval_warships_2 WHERE "tons_l_ton" = '1.150'

Question: List the ship with 1x115-2x70-2x12-pounders for primary artillery.
SQL: SELECT "warship" FROM naval_warships_2 WHERE "main_artillery" = '1x115-2x70-2x12-pounders'