user: ### NOW ANSWER:
Question: What was the lowest number in Pernambuco where the Northeast had a total of 119978?
Columns: ['Animal', 'Bahia', 'Pernambuco', 'Ceará', 'Rio G do Norte', 'Alagoas', 'Northeast Total', 'BR Ranking & %']
Types: ['text', 'real', 'real', 'real', 'real', 'real', 'text', 'text']
Sample row: ['Goats', 3187839.0, 1595069.0, 976880.0, 401510.0, 67549.0, '8633722', '1st - 91.36%']
SQL:

assistant: SELECT MIN("Pernambuco") FROM "Table" WHERE "Northeast Total" = '119978';