What is the aveage Egypt Cup value for players with 0 CAF Champions League goals, 6 Egyptian Premier League goals, and totals under 6?
CREATE TABLE table_name_93 (egypt_cup INTEGER, total VARCHAR, caf_champions_league VARCHAR, egyptian_premier_league VARCHAR)
SELECT AVG(egypt_cup) FROM table_name_93 WHERE caf_champions_league = 0 AND egyptian_premier_league = 6 AND total < 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_93 (egypt_cup INTEGER, total VARCHAR, caf_champions_league VARCHAR, egyptian_premier_league VARCHAR) Question: What is the aveage Egypt Cup value for players with 0 CAF Champions League goals, 6 Egyptian Premier League goals, and totals under 6? [/INST] SELECT AVG(egypt_cup) FROM table_name_93 WHERE caf_champions_league = 0 AND egyptian_premier_league = 6 AND total < 6 </s>