Query 11. Clubs with repeated playoff qualification

Clubs with repeated playoff qualification.

capture the result grid in phpMyAdmin after running the query.

SELECT
    t.team_name,
    c.country_name,
    COUNT(*) AS playoff_seasons,
    AVG(ts.playoff_seed) AS avg_seed,
    MAX(ts.final_rank) AS best_finish_rank
FROM team_seasons ts
INNER JOIN teams t ON t.team_id = ts.team_id
INNER JOIN countries c ON c.country_id = t.country_id
WHERE ts.qualified_playoffs = 1
GROUP BY t.team_id, t.team_name, c.country_name
HAVING COUNT(*) >= 4
ORDER BY playoff_seasons DESC, avg_seed ASC;