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 = 3210 AND sportID = 16
ORDER BY seasonName DESC
Chaminade-Madonna High School Girls Basketball Amyosport High School Sports