Table: sherif_ashraf
Columns: name
egyptian_premier_league
egypt_cup
caf_champions_league
total

Question: What is the highest total for players with under 2 Egyptian Premier League goals and 0 Egypt Cup goals?
SQL: SELECT MAX("total") FROM sherif_ashraf WHERE "egyptian_premier_league" < 2 AND "egypt_cup" < 0

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?
SQL: SELECT AVG("egypt_cup") FROM sherif_ashraf WHERE "caf_champions_league" = 0 AND "egyptian_premier_league" = 6 AND "total" < 6