How many baseball players are there?
select count(*) from player_college
How about the number of colleges?
select count(*) from college
How many baseball players are there in each college?
select t1.name_full, count(*) from college as t1 join player_college as t2 on t1.college_id = t2.college_id group by t1.college_id;
Can you order the results by the number of baseball players in descending order?
select t1.name_full, count(*) 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
Please give me the full name and id of the first college.
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;