How many caps have a Position of prop, and a Player of rui cordeiro?
CREATE TABLE table_name_6 (caps VARCHAR, position VARCHAR, player VARCHAR)
SELECT COUNT(caps) FROM table_name_6 WHERE position = "prop" AND player = "rui cordeiro"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_6 (caps VARCHAR, position VARCHAR, player VARCHAR) Question: How many caps have a Position of prop, and a Player of rui cordeiro? [/INST] SELECT COUNT(caps) FROM table_name_6 WHERE position = "prop" AND player = "rui cordeiro" </s>