what is the full name and id of the college with the largest number of baseball players?
create table player_college (college_id varchar, PRIMARY KEY (college_id)); create table college (name_full varchar, college_id varchar, PRIMARY KEY (name_full))
select t1.name_full, t1.college_id from college as t1 join player_college as t2 on t1.college_id = t2.college_id group by t1.college_id order by count(*) desc limit 1