user: ### NOW ANSWER:
Question: How many providers have a destination of Blackpool?
Columns: ['Route Number', 'Origin', 'Intermediate stops', 'Destination', 'Provider']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [318.0, 'Birmingham', 'Cheltenham, Gloucester', 'Bristol', 'National Express']
SQL:

assistant: SELECT COUNT("Provider") FROM "Table" WHERE "Destination" = 'Blackpool';