Table: concacaf_club_rankings
Columns: rank
country
winner
runner_up
losing_semi_finalist

Question: Which Rank has a Losing Semi- finalist larger than 1, and a Winner smaller than 5?
SQL: SELECT "rank" FROM concacaf_club_rankings WHERE "losing_semi_finalist" > 1 AND "winner" < 5

Question: Which Rank has a Country of costa rica, and a Losing Semi- finalist larger than 1?
SQL: SELECT AVG("rank") FROM concacaf_club_rankings WHERE "country" = 'costa rica' AND "losing_semi_finalist" > 1

Question: Which Rank has a Runner -up smaller than 0?
SQL: SELECT MAX("rank") FROM concacaf_club_rankings WHERE "runner_up" < 0