Table: maghreb_cup_winners
Columns: rank
club
winners
runners_up
third

Question: Which Rank has a Third of 2, and Winners smaller than 2?
SQL: SELECT AVG("rank") FROM maghreb_cup_winners WHERE "third" = 2 AND "winners" < 2

Question: How many Winners have a Third of 1, and Runners-up smaller than 0?
SQL: SELECT COUNT("winners") FROM maghreb_cup_winners WHERE "third" = 1 AND "runners_up" < 0

Question: Which Third has Runners-up of 0, and Winners of 0, and a Club of far rabat?
SQL: SELECT AVG("third") FROM maghreb_cup_winners WHERE "runners_up" = 0 AND "winners" = 0 AND "club" = 'far rabat'

Question: Which Winners is the highest one that has a Rank larger than 7, and a Third smaller than 1?
SQL: SELECT MAX("winners") FROM maghreb_cup_winners WHERE "rank" > 7 AND "third" < 1