Query 1. Season standings board with club and venue context

Season standings board with club and venue context.

capture the result grid in phpMyAdmin after running the query.

SELECT
    s.season_label,
    ts.final_rank,
    t.team_name,
    c.country_name,
    a.arena_name,
    ts.wins,
    ts.losses,
    ROUND(ts.wins / NULLIF(ts.wins + ts.losses, 0), 3) AS win_pct,
    ts.point_diff
FROM team_seasons ts
INNER JOIN seasons s ON s.season_id = ts.season_id
INNER JOIN teams t ON t.team_id = ts.team_id
INNER JOIN countries c ON c.country_id = t.country_id
LEFT JOIN arenas a ON a.arena_id = t.home_arena_id
ORDER BY s.season_id DESC, ts.final_rank ASC, t.team_name ASC;