user: ### NOW ANSWER:
Question: How many were promoted from the league when Esher was relegated to the league?
Columns: ['Season', 'Name', 'Teams', 'Relegated to league', 'Promoted to league', 'Promoted from league', 'Relegated from league']
Types: ['text', 'text', 'real', 'text', 'text', 'text', 'text']
Sample row: ['2005–06', 'National Division Two', 14.0, 'Henley Hawks Orrell', 'Barking Halifax Redruth', 'Moseley Waterloo', 'Orrell']
SQL:

assistant: SELECT COUNT("Promoted from league") FROM "Table" WHERE "Relegated to league" = 'Esher';