What's the average hours per week all students played football?
select avg ( HoursPerWeek )  from SportsInfo where SportName = 'Football'
average hours per week = AVG(HoursPerWeek); all students played football refers to filtering records with SportName = 'Football';