Query 12. Coach records by club

Coach records by club.

capture the result grid in phpMyAdmin after running the query.

SELECT
    CONCAT(p.first_name, ' ', p.last_name) AS coach_name,
    t.team_name,
    COUNT(*) AS seasons_coached,
    SUM(ts.wins) AS total_wins,
    SUM(ts.losses) AS total_losses,
    ROUND(SUM(ts.wins) / NULLIF(SUM(ts.wins) + SUM(ts.losses), 0), 3) AS win_pct
FROM team_seasons ts
INNER JOIN coaches cch ON cch.person_id = ts.coach_person_id
INNER JOIN people p ON p.person_id = cch.person_id
INNER JOIN teams t ON t.team_id = ts.team_id
GROUP BY cch.person_id, p.first_name, p.last_name, t.team_name
HAVING COUNT(*) >= 2
ORDER BY win_pct DESC, total_wins DESC;