SELECT `team`,SUM(`for`) as `for`,SUM(`against`) as `against` ,SUM(`home`) as `home` FROM `element_fixture` WHERE `team` IN (SELECT `team_id` FROM
`teams` WHERE `school_id`=2 and `sport_id`=1) AND `for` > -1 AND `against` > -1 GROUP BY `team` ORDER BY `team`;

SELECT `team`,COUNT(`fixture_id`) AS `won` FROM `element_fixture` WHERE `team` IN (SELECT `team_id` FROM `teams` WHERE `school_id`=2 and
`sport_id`=1) AND `for` > `against` GROUP BY `team`;

SELECT `team`,COUNT(`fixture_id`) AS `lost` FROM `element_fixture` WHERE `team` IN (SELECT `team_id` FROM `teams` WHERE `school_id`=2 and
`sport_id`=1) AND `for` < `against` GROUP BY `team`;

SELECT `team`,COUNT(`fixture_id`) AS `draw` FROM `element_fixture` WHERE `team` IN (SELECT `team_id` FROM `teams` WHERE `school_id`=2 and
`sport_id`=1) AND `for` = `against` GROUP BY `team`;