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 = 1235 AND sportID = 7
ORDER BY seasonName DESC
De La Salle High School Volleyball Amyosport High School Sports