seasons team ch.wins promotions relegations
seasons
team
ch.wins
promotions
relegations
number
number
number
number
number text number number number
10 basket rimini crabs 0 0 0
which three teams have been playing for the most seasons ?
WDT CD NNS VBD-AUX VBD-AUX VBG IN DT RBS NNS .
Basket Rimini Crabs|Aurora Basket Jesi|Andrea Costa Imola
select c2 from w where c1_number = ( select max ( c1_number ) from w )