What is the most common sport name those students played?
SELECT sportName,count ( * )  from sportsinfo where stuid in  ( select stuid from student where age < 20 )  group by sportname order by count ( * )  desc limit 1
most common sport name refers to MAX(COUNT(sportName)); students played refers to a condition on student age less than 20;