With the Royal Navy as Combatants B, what was the result?
CREATE TABLE table_26977890_1 (result VARCHAR, combatants_b VARCHAR)
SELECT result FROM table_26977890_1 WHERE combatants_b = "Royal Navy"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_26977890_1 (result VARCHAR, combatants_b VARCHAR) Question: With the Royal Navy as Combatants B, what was the result? [/INST] SELECT result FROM table_26977890_1 WHERE combatants_b = "Royal Navy" </s>