Which club had fewer than 29 goals against and a difference smaller than 26?
CREATE TABLE table_name_47 (club VARCHAR, goals_against VARCHAR, goal_difference VARCHAR)
SELECT club FROM table_name_47 WHERE goals_against < 29 AND goal_difference < 26
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (club VARCHAR, goals_against VARCHAR, goal_difference VARCHAR) Question: Which club had fewer than 29 goals against and a difference smaller than 26? [/INST] SELECT club FROM table_name_47 WHERE goals_against < 29 AND goal_difference < 26 </s>