what is the total number of pick # where nhl team is philadelphia flyers
CREATE TABLE table_1213511_7 (pick__number VARCHAR, nhl_team VARCHAR)
SELECT COUNT(pick__number) FROM table_1213511_7 WHERE nhl_team = "Philadelphia Flyers"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1213511_7 (pick__number VARCHAR, nhl_team VARCHAR) Question: what is the total number of pick # where nhl team is philadelphia flyers [/INST] SELECT COUNT(pick__number) FROM table_1213511_7 WHERE nhl_team = "Philadelphia Flyers" </s>