What is the population of northfield parish that has an area less than 342.4?
CREATE TABLE table_name_50 (population INTEGER, area_km_2 VARCHAR, official_name VARCHAR)
SELECT SUM(population) FROM table_name_50 WHERE area_km_2 < 342.4 AND official_name = "northfield"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (population INTEGER, area_km_2 VARCHAR, official_name VARCHAR) Question: What is the population of northfield parish that has an area less than 342.4? [/INST] SELECT SUM(population) FROM table_name_50 WHERE area_km_2 < 342.4 AND official_name = "northfield" </s>