What is the rd number where the reg GP is 0 and the pick is 150?
CREATE TABLE table_name_24 (rd__number VARCHAR, reg_gp VARCHAR, pick__number VARCHAR)
SELECT COUNT(rd__number) FROM table_name_24 WHERE reg_gp = 0 AND pick__number = 150
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_24 (rd__number VARCHAR, reg_gp VARCHAR, pick__number VARCHAR) Question: What is the rd number where the reg GP is 0 and the pick is 150? [/INST] SELECT COUNT(rd__number) FROM table_name_24 WHERE reg_gp = 0 AND pick__number = 150 </s>