What is the full name and id of the college with the largest number of baseball players?
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
And how many players go there?
select count ( distinct player_id ) from player_college where college_id = ( select 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 )
And where is that college located?
select t1.city, t1.state, t1.country 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
And what year did the largest number of baseball players attend that college?
select year from player_college where college_id = ( select 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 ) group by college_id order by year desc limit 1
How many baseball players attended that college in 2018?
select count ( player_id ) from player_college where year = "2018" and college_id = "texas"