what is the overall number of chosen ideas where the person is scott parker
CREATE TABLE table_2840500_3 (pick VARCHAR, player VARCHAR)
SELECT COUNT(pick) FROM table_2840500_3 WHERE player = "Scott Parker"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2840500_3 (pick VARCHAR, player VARCHAR) Question: what is the overall number of chosen ideas where the person is scott parker [/INST] SELECT COUNT(pick) FROM table_2840500_3 WHERE player = "Scott Parker" </s>