What is Highest Number of Bearers 2008, when Surname is Jacobsen?
CREATE TABLE table_name_87 (number_of_bearers_2008 INTEGER, surname VARCHAR)
SELECT MAX(number_of_bearers_2008) FROM table_name_87 WHERE surname = "jacobsen"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_87 (number_of_bearers_2008 INTEGER, surname VARCHAR) Question: What is Highest Number of Bearers 2008, when Surname is Jacobsen? [/INST] SELECT MAX(number_of_bearers_2008) FROM table_name_87 WHERE surname = "jacobsen" </s>