When tommy smith category:articles with hcards is the player and 1 is the goal how many cap(s) are there?
CREATE TABLE table_28286776_50 (cap_s_ VARCHAR, goal_s_ VARCHAR, player VARCHAR)
SELECT COUNT(cap_s_) FROM table_28286776_50 WHERE goal_s_ = 1 AND player = "Tommy Smith Category:Articles with hCards"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_28286776_50 (cap_s_ VARCHAR, goal_s_ VARCHAR, player VARCHAR) Question: When tommy smith category:articles with hcards is the player and 1 is the goal how many cap(s) are there? [/INST] SELECT COUNT(cap_s_) FROM table_28286776_50 WHERE goal_s_ = 1 AND player = "Tommy Smith Category:Articles with hCards" </s>