Which teams have had victories?
select t2.name, t1.team_id_winner from postseason as t1 join team as t2 on t1.team_id_winner = t2.team_id_br group by t1.team_id_winner
How about in 2008 postseason?
select t2.name, t1.team_id_winner from postseason as t1 join team as t2 on t1.team_id_winner = t2.team_id_br where t1.year = 2008 group by t1.team_id_winner
Among the results, which team has had the fewest victories?
select t2.name, t1.team_id_winner from postseason as t1 join team as t2 on t1.team_id_winner = t2.team_id_br where t1.year = 2008 group by t1.team_id_winner order by count(*) asc limit 1;
How about the team with the most victories?
select t2.name, t1.team_id_winner from postseason as t1 join team as t2 on t1.team_id_winner = t2.team_id_br where t1.year = 2008 group by t1.team_id_winner order by count(*) desc limit 1;