Farr Yacht Design designed boats for how many country/flags?
CREATE TABLE table_19872699_1 (flag VARCHAR, design_firm VARCHAR)
SELECT COUNT(flag) FROM table_19872699_1 WHERE design_firm = "Farr Yacht Design"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_19872699_1 (flag VARCHAR, design_firm VARCHAR) Question: Farr Yacht Design designed boats for how many country/flags? [/INST] SELECT COUNT(flag) FROM table_19872699_1 WHERE design_firm = "Farr Yacht Design" </s>