How many students play football?
select count ( * ) from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.sportname = "Football"
What are their first and last names?
select t2.lname, t2.fname from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.sportname = "Football"
How many students play Lacrosse?
select count ( * ) from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.sportname = "Lacrosse"
What are their first and last names?
select t2.lname, t2.fname from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.sportname = "Lacrosse"