SCHEMA:
CREATE TABLE table_name_93 (egypt_cup INTEGER, total VARCHAR, caf_champions_league VARCHAR, egyptian_premier_league VARCHAR)
User 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?


SELECT AVG(egypt_cup) FROM table_name_93 WHERE caf_champions_league = 0 AND egyptian_premier_league = 6 AND total < 6