A "later final" is counted regardless of which event it's in - a non-finalist in one discipline who later reaches a final in a different one still counts, since the question here is whether sending the athlete at all was a good investment, not whether that specific event entry was. Winning a medal, rather than just reaching a final, was tried first but produced counts too small to be usable - single digits across the whole comparison - so this page uses "reached a final" as the success criterion instead. Combined events (decathlon, heptathlon) are excluded from the Run/Jump/Throw split entirely, since they don't belong cleanly in one of the three; their individual-leg marks are also excluded from every other event's entrant count, since World Athletics' data records e.g. a decathlete's 100m leg as a row under the standalone "100m" event too (marked race = 'Combined - Group', not 'Final') - without excluding those rows, decathletes would be double-counted as entrants in events they never separately entered.

Main query ($windowYears = 3):

        WITH gb_entrants AS (
            SELECT DISTINCT r.competitionId, r.aaId, r.eventId, c1.startDate AS tDate,
                   CASE WHEN e.event_short IN ('HJ','PV','LJ','TJ') THEN 'Jump'
                        WHEN e.event_short IN ('Shot','Discus','Hammer','Javelin') THEN 'Throw'
                        ELSE 'Run' END AS discGroup
            FROM athletics_wa_competition_results r
            JOIN athletics_wa_competitions c1 ON c1.competitionId = r.competitionId
            JOIN athletics_wa_events e ON e.eventId = r.eventId
            WHERE r.competitionId IN (7093740,7105084,7125365,7132391,7147634)
              AND r.aaId > 0
              AND r.race <> 'Combined - Group'
              AND e.event_short <> 'Combined'
              AND SUBSTRING_INDEX(r.athleteUrlSlug, '/', 1) = 'great-britain-ni'
        ),
        gb_finalists AS (
            SELECT DISTINCT r.competitionId, r.aaId, r.eventId
            FROM athletics_wa_competition_results r
            WHERE r.competitionId IN (7093740,7105084,7125365,7132391,7147634)
              AND r.race = 'Final'
              AND r.aaId > 0
              AND SUBSTRING_INDEX(r.athleteUrlSlug, '/', 1) = 'great-britain-ni'
        ),
        non_finalists AS (
            SELECT ge.*
            FROM gb_entrants ge
            LEFT JOIN gb_finalists gf
                ON gf.competitionId = ge.competitionId AND gf.aaId = ge.aaId AND gf.eventId = ge.eventId
            WHERE gf.aaId IS NULL
        )
        SELECT nf.competitionId, nf.discGroup,
               COUNT(DISTINCT nf.aaId) AS nonFinalists,
               COUNT(DISTINCT CASE WHEN EXISTS (
                   SELECT 1 FROM athletics_wa_competition_results r2
                   JOIN athletics_wa_competitions c2 ON c2.competitionId = r2.competitionId
                   WHERE r2.aaId = nf.aaId
                     AND r2.race = 'Final'
                     AND c2.type IN ('E', 'O+W')
                     AND c2.startDate > nf.tDate
                     AND c2.startDate <= DATE_ADD(nf.tDate, INTERVAL 3 YEAR)
               ) THEN nf.aaId END) AS laterFinalists
        FROM non_finalists nf
        GROUP BY nf.competitionId, nf.discGroup