What is the total number of German submarines lost with more than 120958 sunk by mines?
CREATE TABLE table_name_46 (german_submarines_lost VARCHAR, sunk_by_mines INTEGER)
SELECT COUNT(german_submarines_lost) FROM table_name_46 WHERE sunk_by_mines > 120958
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_46 (german_submarines_lost VARCHAR, sunk_by_mines INTEGER) Question: What is the total number of German submarines lost with more than 120958 sunk by mines? [/INST] SELECT COUNT(german_submarines_lost) FROM table_name_46 WHERE sunk_by_mines > 120958 </s>