Table: bus_routes
Columns: route_number
origin
intermediate_stops
destination
provider

Question: Who are all providers with destination of Liverpool?
SQL: SELECT "provider" FROM bus_routes WHERE "destination" = 'Liverpool'

Question: What is every entry for intermediate stops for the destination of Manchester?
SQL: SELECT "intermediate_stops" FROM bus_routes WHERE "destination" = 'Manchester'

Question: How many route numbers occur for the origin of Birmingham and destination of Bristol?
SQL: SELECT COUNT("route_number") FROM bus_routes WHERE "origin" = 'Birmingham' AND "destination" = 'Bristol'

Question: What is every origin for the destination of Manchester?
SQL: SELECT "origin" FROM bus_routes WHERE "destination" = 'Manchester'

Question: How many providers have a destination of Blackpool?
SQL: SELECT COUNT("provider") FROM bus_routes WHERE "destination" = 'Blackpool'