CREATE TABLE table_3005999_1 (route_number VARCHAR2, origin VARCHAR2, destination VARCHAR2)

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