user: ### NOW ANSWER:
Question: Name the name for Henley Manchester
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: ['1996–97', 'Courage Championship Division One', 12.0, 'None', 'Coventry Rugby Lions Rotherham Richmond', 'Richmond Newcastle Falcons', 'Rugby Lions Nottingham']
SQL:

assistant: SELECT "Name" FROM "Table" WHERE "Promoted to League" = 'Henley Manchester';