Table: canadian_soccer_league_teams
Columns: team
city
total_seasons
seasons
highest_league

Question: What's the highest league of the Nova Scotia Clippers with a total season of less than 4?
SQL: SELECT "highest_league" FROM canadian_soccer_league_teams WHERE "total_seasons" < 4 AND "team" = 'nova scotia clippers'

Question: What is the season that has fewer than 5 total seasons and is in Ottawa, Ontario?
SQL: SELECT "seasons" FROM canadian_soccer_league_teams WHERE "total_seasons" < 5 AND "city" = 'ottawa, ontario'

Question: What is the least total seasons of the Vancouver 86ers?
SQL: SELECT MIN("total_seasons") FROM canadian_soccer_league_teams WHERE "team" = 'vancouver 86ers'