SELECT wins, losses, ties, season.name AS 'seasonName', school_standings.season_id
FROM school_standings
INNER JOIN season ON school_standings.season_id = season.season_id
WHERE schoolID = 4341 AND sportID = 12
ORDER BY seasonName DESC
Warren Township High School Lacrosse Amyosport High School Sports