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_79 (city VARCHAR, rank VARCHAR, airport VARCHAR)
  ### Question:
  What city is ranked greater than 6, and the airport is St. Petersburg/Clearwater (PIE)
  ### Answer:
  SELECT city FROM table_name_79 WHERE rank > 6 AND airport = "st. petersburg/clearwater (pie)"