What is the total population with less than 789 males?
CREATE TABLE table_name_12 (total_population VARCHAR, male INTEGER)
SELECT COUNT(total_population) FROM table_name_12 WHERE male < 789
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_12 (total_population VARCHAR, male INTEGER) Question: What is the total population with less than 789 males? [/INST] SELECT COUNT(total_population) FROM table_name_12 WHERE male < 789 </s>