These are the numbers from our database.

julia> db = SQLite.DB("sql/wn.db")
SQLite.DB("sql/wn.db")

julia> sql = WeatherNews.DB.sql_fn(db)
(::WeatherNews.DB.var"#sql#sql_fn##0"{SQLite.DB}) (generic function with 2 methods)

julia> q = """
       SELECT title,
              SUM(c) AS n
         FROM (SELECT seg.id,
                      seg.n AS title,
                      s.caster_id = ? AS c
                 FROM segment seg
                      LEFT JOIN schedule s ON s.segment_id = seg.id
                      JOIN caster c ON c.id = s.caster_id
                WHERE s.jst LIKE '2025%'
                ORDER BY seg.id) seg2
        GROUP BY title
        ORDER BY id;
       """;

julia> casters = ["ailin", "sayane", "matsu", "shirai", "takayama", "komaki2018", "tokita", "ogawa", "uozumi", "aohara2023", "okamoto2023", "tanabe2025", "matsumoto2025", "kawabata", "fukuyoshi"];

julia> count2025 = map(caster -> (caster => sql(q, [caster_id[caster]])), casters);

julia> tab2025 = reduce((res, pair) -> hcat(res, DataFrame(pair.first => pair.second[!, :n]); makeunique=true), count2025; init=count2025[1].second[!, :title])
8×16 DataFrame
 Row │ x1           ailin  sayane  matsu  shirai  takayama  komaki2018  tokita  ogawa  uozumi  aohara2023  okamoto2023  tanabe2025  matsumoto2025  kawabata  fukuyoshi 
     │ String       Int64  Int64   Int64  Int64   Int64     Int64       Int64   Int64  Int64   Int64       Int64        Int64       Int64          Int64     Int64     
─────┼─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
   1 │ Morning          0       0      0       0         0           0       0     29      72          71            0          27             28         0         75
   2 │ Sunshine         0       1      1      15         0           0       0     36      66          73            3          34             38         9         29
   3 │ Coffee Time      2       5    100      21         0           0       9     23      30          33           22          30             33        37          4
   4 │ Afternoon       41      24      1      48         0          17      47     51      23          24           21          14              9        25          0
   5 │ Evening         55       0      0       7         0          79      90     21       1           5           79           0              1         1          0
   6 │ Moon            67       0      0       0         0         121      55     31       0           1           77           0              0         0          0
   7 │ _                4       0      0       0         0           0       1      0       0           0            1           0              0         0          0
   8 │ au PAY           5       3      3       5         0           7       8      9       8           8            7           3              3         0          0