Table: rugby_league_teams
Columns: season
name
teams
relegated_to_league
promoted_to_league
promoted_from_league
relegated_from_league

Question: How many seasons did Barking Birmingham & Solihull Stourbridge were relegated from league?
SQL: SELECT COUNT("season") FROM rugby_league_teams WHERE "relegated_from_league" = 'Barking Birmingham & Solihull Stourbridge'

Question: Who was relegated to league if Barking Birmingham & Solihull Stourbridge were relegated from league?
SQL: SELECT "relegated_to_league" FROM rugby_league_teams WHERE "relegated_from_league" = 'Barking Birmingham & Solihull Stourbridge'

Question: How many were the minimum team that participated in the league?
SQL: SELECT MIN("teams") FROM rugby_league_teams

Question: How many teams participated (maximum) when Cornish All Blacks Pertemps Bees were relegated to the league?
SQL: SELECT MAX("teams") FROM rugby_league_teams WHERE "relegated_to_league" = 'Cornish All Blacks Pertemps Bees'

Question: Who was promoted to the league when Coventry was relegated to the league?
SQL: SELECT "promoted_to_league" FROM rugby_league_teams WHERE "relegated_to_league" = 'Coventry'

Question: How many were promoted from the league when Esher was relegated to the league?
SQL: SELECT COUNT("promoted_from_league") FROM rugby_league_teams WHERE "relegated_to_league" = 'Esher'