What club/province does the prop player with over 45 caps play for?
CREATE TABLE table_name_27 (club_province VARCHAR, caps VARCHAR, position VARCHAR)
SELECT club_province FROM table_name_27 WHERE caps > 45 AND position = "prop"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_27 (club_province VARCHAR, caps VARCHAR, position VARCHAR) Question: What club/province does the prop player with over 45 caps play for? [/INST] SELECT club_province FROM table_name_27 WHERE caps > 45 AND position = "prop" </s>