What is the rank of the park in pigeon forge, tennessee in the best food category?
CREATE TABLE table_name_57 (rank VARCHAR, location VARCHAR, category VARCHAR)
SELECT COUNT(rank) FROM table_name_57 WHERE location = "pigeon forge, tennessee" AND category = "best food"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_57 (rank VARCHAR, location VARCHAR, category VARCHAR) Question: What is the rank of the park in pigeon forge, tennessee in the best food category? [/INST] SELECT COUNT(rank) FROM table_name_57 WHERE location = "pigeon forge, tennessee" AND category = "best food" </s>