What is Stop No., when Destination is Perth, and when Line is Midland?
CREATE TABLE table_name_23 (stop_no VARCHAR, destination VARCHAR, line VARCHAR)
SELECT stop_no FROM table_name_23 WHERE destination = "perth" AND line = "midland"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (stop_no VARCHAR, destination VARCHAR, line VARCHAR) Question: What is Stop No., when Destination is Perth, and when Line is Midland? [/INST] SELECT stop_no FROM table_name_23 WHERE destination = "perth" AND line = "midland" </s>