Which player has a Club/province of direito, less than 21 caps, and a Position of lock?
CREATE TABLE table_name_99 (player VARCHAR, position VARCHAR, club_province VARCHAR, caps VARCHAR)
SELECT player FROM table_name_99 WHERE club_province = "direito" AND caps < 21 AND position = "lock"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (player VARCHAR, position VARCHAR, club_province VARCHAR, caps VARCHAR) Question: Which player has a Club/province of direito, less than 21 caps, and a Position of lock? [/INST] SELECT player FROM table_name_99 WHERE club_province = "direito" AND caps < 21 AND position = "lock" </s>