How many storms had death records?
CREATE TABLE storm (Number_Deaths INTEGER)
SELECT COUNT(*) FROM storm WHERE Number_Deaths > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE storm (Number_Deaths INTEGER) Question: How many storms had death records? [/INST] SELECT COUNT(*) FROM storm WHERE Number_Deaths > 0 </s>