How long is the UK's Ballochmyle Viaduct?
CREATE TABLE table_name_97 (
    longest_span_in_s_metre___feet__ VARCHAR,
    land VARCHAR,
    name VARCHAR
)
SELECT longest_span_in_s_metre___feet__ FROM table_name_97 WHERE land = "uk" AND name = "ballochmyle viaduct"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How long is the UK's Ballochmyle Viaduct? ### Input: CREATE TABLE table_name_97 (
    longest_span_in_s_metre___feet__ VARCHAR,
    land VARCHAR,
    name VARCHAR
) ### Response: SELECT longest_span_in_s_metre___feet__ FROM table_name_97 WHERE land = "uk" AND name = "ballochmyle viaduct"