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)"
context: CREATE TABLE table_name_79 (city VARCHAR, rank VARCHAR, airport VARCHAR)