How many students are playing multiple sports?
SELECT count ( * )  FROM  ( SELECT * FROM Sportsinfo GROUP BY StuID having count ( * )  > 1 ) 
students playing multiple sports refers to COUNT(DISTINCT StuID) WHERE the same StuID appears in more than one sport;