SELECT College FROM match_season GROUP BY College ORDER BY count(*) DESC LIMIT 3
What are the three colleges from which the most players are from?
SELECT College FROM match_season GROUP BY College ORDER BY count ( * ) DESC LIMIT 3
select college from match_season group by college order by count ( * ) desc limit value
What are the three colleges from which the most players are from ?