What was the lowest number in Pernambuco where the Northeast had a total of 119978?
CREATE TABLE table_name_55 (pernambuco INTEGER, northeast_total VARCHAR)
SELECT MIN(pernambuco) FROM table_name_55 WHERE northeast_total = "119978"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_55 (pernambuco INTEGER, northeast_total VARCHAR) Question: What was the lowest number in Pernambuco where the Northeast had a total of 119978? [/INST] SELECT MIN(pernambuco) FROM table_name_55 WHERE northeast_total = "119978" </s>