How many route numbers occur for the origin of Birmingham and destination of Bristol?
CREATE TABLE table_3005999_1 (route_number VARCHAR, origin VARCHAR, destination VARCHAR)
SELECT COUNT(route_number) FROM table_3005999_1 WHERE origin = "Birmingham" AND destination = "Bristol"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_3005999_1 (route_number VARCHAR, origin VARCHAR, destination VARCHAR) Question: How many route numbers occur for the origin of Birmingham and destination of Bristol? [/INST] SELECT COUNT(route_number) FROM table_3005999_1 WHERE origin = "Birmingham" AND destination = "Bristol" </s>