What is the sum of the appearances at the league cup for the defender who had less than 10 appearances at the UEFA cup?
CREATE TABLE table_name_29 (league_cup INTEGER, position VARCHAR, UEfa_cup VARCHAR)
SELECT SUM(league_cup) FROM table_name_29 WHERE position = "defender" AND UEfa_cup < 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_29 (league_cup INTEGER, position VARCHAR, UEfa_cup VARCHAR) Question: What is the sum of the appearances at the league cup for the defender who had less than 10 appearances at the UEFA cup? [/INST] SELECT SUM(league_cup) FROM table_name_29 WHERE position = "defender" AND UEfa_cup < 10 </s>