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 = 13046 AND sportID = 2
ORDER BY seasonName DESC
Klein High School Softball Amyosport High School Sports