what is the number of smallpox when typhoid fever is 293
CREATE TABLE table_1007688_1 (smallpox INTEGER, typhoid_fever VARCHAR)
SELECT MAX(smallpox) FROM table_1007688_1 WHERE typhoid_fever = 293
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1007688_1 (smallpox INTEGER, typhoid_fever VARCHAR) Question: what is the number of smallpox when typhoid fever is 293 [/INST] SELECT MAX(smallpox) FROM table_1007688_1 WHERE typhoid_fever = 293 </s>