Which Sport has a Founded larger than 1874 and a Club of birmingham city?
CREATE TABLE table_name_71 (sport VARCHAR, founded VARCHAR, club VARCHAR)
SELECT sport FROM table_name_71 WHERE founded > 1874 AND club = "birmingham city"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_71 (sport VARCHAR, founded VARCHAR, club VARCHAR) Question: Which Sport has a Founded larger than 1874 and a Club of birmingham city? [/INST] SELECT sport FROM table_name_71 WHERE founded > 1874 AND club = "birmingham city" </s>