What city is ranked greater than 6, and the airport is St. Petersburg/Clearwater (PIE)
CREATE TABLE table_name_79 (city VARCHAR, rank VARCHAR, airport VARCHAR)
SELECT city FROM table_name_79 WHERE rank > 6 AND airport = "st. petersburg/clearwater (pie)"
<s>[INST] Write mssql query to answer the following question given the database schema. 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) [/INST] SELECT city FROM table_name_79 WHERE rank > 6 AND airport = "st. petersburg/clearwater (pie)" </s>