Table schema:
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)
SQL: SELECT city FROM table_name_79 WHERE rank > 6 AND airport = "st. petersburg/clearwater (pie)"