What is the average work number of Snowdon Ranger with the builder Vulcan Foundry?
CREATE TABLE table_name_57 (works_number INTEGER, builder VARCHAR, name VARCHAR)
SELECT AVG(works_number) FROM table_name_57 WHERE builder = "vulcan foundry" AND name = "snowdon ranger"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_57 (works_number INTEGER, builder VARCHAR, name VARCHAR) Question: What is the average work number of Snowdon Ranger with the builder Vulcan Foundry? [/INST] SELECT AVG(works_number) FROM table_name_57 WHERE builder = "vulcan foundry" AND name = "snowdon ranger" </s>