How many engines were built with a cylinder size of 20 ½” x 26”, firebox is belpaire and valve gear is from Stephenson?
CREATE TABLE table_25695027_1 (number_built VARCHAR, valve_gear VARCHAR, cylinder_size VARCHAR, firebox VARCHAR)
SELECT number_built FROM table_25695027_1 WHERE cylinder_size = "20 ½” x 26”" AND firebox = "Belpaire" AND valve_gear = "Stephenson"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_25695027_1 (number_built VARCHAR, valve_gear VARCHAR, cylinder_size VARCHAR, firebox VARCHAR) Question: How many engines were built with a cylinder size of 20 ½” x 26”, firebox is belpaire and valve gear is from Stephenson? [/INST] SELECT number_built FROM table_25695027_1 WHERE cylinder_size = "20 ½” x 26”" AND firebox = "Belpaire" AND valve_gear = "Stephenson" </s>