How many providers have a destination of Blackpool?
CREATE TABLE table_3005999_1 (provider VARCHAR, destination VARCHAR)
SELECT COUNT(provider) FROM table_3005999_1 WHERE destination = "Blackpool"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_3005999_1 (provider VARCHAR, destination VARCHAR) Question: How many providers have a destination of Blackpool? [/INST] SELECT COUNT(provider) FROM table_3005999_1 WHERE destination = "Blackpool" </s>