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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the total population with less than 789 males? ### Input: CREATE TABLE table_name_12 (
    total_population VARCHAR,
    male INTEGER
) ### Response: SELECT COUNT(total_population) FROM table_name_12 WHERE male < 789