What is the sum of tonnage with a time at 00:10 and less than 42 casualties?
CREATE TABLE table_name_30 (tonnage__grt_ INTEGER, time VARCHAR, casualties VARCHAR)
SELECT SUM(tonnage__grt_) FROM table_name_30 WHERE time = "00:10" AND casualties < 42
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (tonnage__grt_ INTEGER, time VARCHAR, casualties VARCHAR) Question: What is the sum of tonnage with a time at 00:10 and less than 42 casualties? [/INST] SELECT SUM(tonnage__grt_) FROM table_name_30 WHERE time = "00:10" AND casualties < 42 </s>