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"
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 was the lowest number in Pernambuco where the Northeast had a total of 119978? ### Input: CREATE TABLE table_name_55 (
    pernambuco INTEGER,
    northeast_total VARCHAR
) ### Response: SELECT MIN(pernambuco) FROM table_name_55 WHERE northeast_total = "119978"