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 = 15062 AND sportID = 1
ORDER BY seasonName DESC
Dimond High School Baseball Amyosport High School Sports