Tell me the total number of % wt comp 1 foR % wt comp 2 or 27
CREATE TABLE table_name_1 (_percentage_wt_comp_1 VARCHAR, _percentage_wt_comp_2 VARCHAR)
SELECT COUNT(_percentage_wt_comp_1) FROM table_name_1 WHERE _percentage_wt_comp_2 = 27
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (_percentage_wt_comp_1 VARCHAR, _percentage_wt_comp_2 VARCHAR) Question: Tell me the total number of % wt comp 1 foR % wt comp 2 or 27 [/INST] SELECT COUNT(_percentage_wt_comp_1) FROM table_name_1 WHERE _percentage_wt_comp_2 = 27 </s>