text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  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?
  ### Answer:
  SELECT MIN(pernambuco) FROM table_name_55 WHERE northeast_total = "119978"