how many drumsets of drumstand (oftenoptional) with hd-1/3stand and tom-tom pads is 3xcloth-head are
CREATE TABLE table_2889300_6 (drumset_name VARCHAR, drumstand__oftenoptional_ VARCHAR, tom_tom_pads VARCHAR)
SELECT COUNT(drumset_name) FROM table_2889300_6 WHERE drumstand__oftenoptional_ = "HD-1/3Stand" AND tom_tom_pads = "3xCloth-Head"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2889300_6 (drumset_name VARCHAR, drumstand__oftenoptional_ VARCHAR, tom_tom_pads VARCHAR) Question: how many drumsets of drumstand (oftenoptional) with hd-1/3stand and tom-tom pads is 3xcloth-head are [/INST] SELECT COUNT(drumset_name) FROM table_2889300_6 WHERE drumstand__oftenoptional_ = "HD-1/3Stand" AND tom_tom_pads = "3xCloth-Head" </s>