How many are named River Esk
CREATE TABLE table_142159_1 (built VARCHAR, name VARCHAR)
SELECT COUNT(built) FROM table_142159_1 WHERE name = "River Esk"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_142159_1 (built VARCHAR, name VARCHAR) Question: How many are named River Esk [/INST] SELECT COUNT(built) FROM table_142159_1 WHERE name = "River Esk" </s>