Show the team_id with highest rank?
select team_id from team order by rank asc limit 1
Show the maximum scores of the team Boston Red Stockings when the team won in postseason?
select max ( t1.wins ) from postseason as t1 join team as t2 on t1.team_id_winner = t2.team_id_br where t2.name = 'Boston red Stockings'
Show the year of postseason with equal wins and loses?
select year from postseason where wins = losses