What is NiCd, when Type is "Capacity under 500mA constant Drain"?
CREATE TABLE table_name_23 (nicd VARCHAR, type VARCHAR)
SELECT nicd FROM table_name_23 WHERE type = "capacity under 500ma constant drain"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (nicd VARCHAR, type VARCHAR) Question: What is NiCd, when Type is "Capacity under 500mA constant Drain"? [/INST] SELECT nicd FROM table_name_23 WHERE type = "capacity under 500ma constant drain" </s>