Q47, run 2026-11-06-0808-sonnet-query
Why do Kesting University and Rostval Technical University swap places in 2024 between full and fractional counting?
Tests: Counting method: why the ranking flips.
Expected: Rostval is on four 2024 works (W21, W27, W28, W29), but on each it has one author of four: 4 x 1/4 = 1. Kesting is on three, with larger shares: W22 alone, half of W20, two of the four authors of W21: 2.
sql run 1
Rostval has more 2024 works (4 against 3), but only as one co-author among several on each. Kesting has fewer works but larger author shares (W22 is sole-authored, and W20 and W21 are shared with other institutions), so it leads on fractional counting.
Why: Gets Kesting's larger shares (sole-authored W22, shared W20/W21) but omits that each Rostval work has four authors with one from Rostval, i.e. a quarter each, and does not say Kesting holds half of W20 and W21.
sql run 2
Rostval has more works under full counting (4 vs 3). Under fractional counting Kesting has more (2.0 vs 1.0). Rostval contributes only one author to each of its four multi-author 2024 papers, so each earns a small share. Kesting has sole-author or high-share papers (W22, W20, W21).
Why: Gets Rostval's one-author-per-paper point and Kesting's larger shares, but never says each paper has four authors (a quarter each) or that W20/W21 are half shares for Kesting.
sql run 3
Rostval has more works in 2024 (4 against 3), but they are shared among 4 authors each, so its fractional total is only 1.0. Kesting's 2024 works have fewer co-authors, giving it 2.0.
Why: Captures that Rostval's works are shared among 4 authors (fractional 1.0) and Kesting has fewer co-authors, but doesn't say only one author per work is from Rostval (a quarter each) or identify Kesting's single-author W22 and half-shares of W20 and W21.
sql run 4
Rostval has one author on each of four multi-author works (W21, W27, W28, W29), so it wins on full counting (4 against 3). Kesting holds the whole of W22 and half of W20 and W21, so it wins on fractional counting (2.0 against 1.0).
Why: Gets Kesting's larger shares (W22 whole, half of W20 and W21) right, but never says Rostval's works each have four authors with one from Rostval, so a quarter each.
sql run 5
Under full counting, Rostval has 4 works in 2024 (W21, W27, W28, W29) against Kesting's 3. Each Rostval work is shared across four authors from different institutions, so it gets only 0.25 each, 1.0 in total. Kesting's W22 is single-author and W20 and W21 split its credit less, giving 2.0.
Why: Gets Rostval's four works with a quarter each (four authors, one from Rostval), but for Kesting it only says W22 is single-author and that W20 and W21 'split credit less', not that Kesting holds half of W20 and W21.
sql+markdown run 1
Rostval has more works in 2024 (4 against 3), but its authors are spread across several institutions, so each work contributes only 0.25. Kesting's authors take larger shares (W22 gives 1 and W20 gives 0.5), which puts it ahead on fractional counts.
Why: Gets Kesting's larger shares (W22=1, W20=0.5) but doesn't say Rostval's works each have four authors with one from Rostval; says 'spread across several institutions' and omits W21 and the four-author detail.
sql+markdown run 2
Rostval has more works in full counting (4 against 3). Kesting has more in fractional counting (2.0 against 1.0) because it holds a larger share of the authors on its works. W20 and W21 are shared and split, and W22 is Kesting's alone.
Why: Gives Kesting's larger shares (W22 solely Kesting's, W20 and W21 split), but never says Rostval's four works each have four authors with one from Rostval, a quarter each.
sql+markdown run 3
Rostval has more works (4 against 3), but they are spread over four-author papers where it holds one author each. Its fractional total is therefore 1.0 against Kesting's 2.0.
Why: Gives the four-author, one-from-Rostval fractional effect but omits Kesting's larger shares (single-author W22 and half of W20/W21).
sql+markdown run 4
Kesting leads under fractional counting because its W22 has a single author and earns a full share of 1. Rostval's four 2024 works each have four authors and earn only 0.25 each, so it leads under full counting (4 works against 3).
Why: Correctly says Rostval's four works have four authors each, 0.25 each, but doesn't mention only one author being from Rostval, and omits Kesting's half shares of W20 and W21 (cites only W22).
sql+markdown run 5
Kesting's 3 works are largely its own authors' work, so it keeps most of the share (2.0). Rostval's 4 works are mostly shared with other institutions' authors, so fractional counting cuts it to 1.0 even though it has more works.
Why: Gives the general idea of shared authorship cutting Rostval's share, but omits the four-authors/one-from-Rostval quarter-each detail and Kesting's W22 single-author review plus half of W20 and W21.
sql+executed run 1
Under full counting Rostval has 4 works (W21, W27, W28, W29) against Kesting's 3. Kesting's authors take larger shares of its works, so fractionally it leads, 2.0 to 1.0.
Why: Says Kesting holds larger shares, but omits Rostval's four-author works giving a quarter each and Kesting's specific W22 single-author and half-shares of W20/W21.
sql+executed run 2
Kesting has fewer works in 2024 (3 against 4) but holds larger author shares on them. Rostval appears on more works, but as one of four authors each time, so its fractional total is lower.
Why: Correctly says Rostval is one of four authors on each work, so its share is lower, and Kesting's shares are larger; but it omits the quarter-each figure and does not name Kesting's single-author review (W22) or its half shares of W20 and W21.
sql+executed run 3
The data does not show a swap. Under full counting Kesting and Rostval tie at 4 each in 2024, and Kesting leads only under fractional counting (3 vs 1). Rostval's works are shared among more outside authors, so each of its works counts for less.
Why: Denies the swap, which contradicts the key. It never mentions Rostval's four-author works at a quarter each, nor Kesting's W22 and half-shares of W20 and W21.
sql+executed run 4
Rostval has more works in 2024 (4 against 3), but its shares are thin: each of its four works is split four ways, giving 1.0. Kesting has W22 sole-authored and half of W20, giving 2.0.
Why: Says Rostval's four works are split four ways (1.0) and Kesting has W22 sole-authored plus half of W20, but omits that only one author per work is from Rostval and does not mention half of W21 explicitly.
sql+executed run 5
Rostval has more works in full counting (4 against 3), but each of its works is shared among 4 authors, so it gets 1.0 in fractional counting. Kesting has the sole-author W22 and half of W20, which gives it 2.0.
Why: Says Rostval's works are shared among 4 authors (quarter each) and Kesting has W22 sole and half of W20, but omits half of W21 and doesn't explicitly say only one of the four authors is from Rostval.
sparql run 1
Rostval (I09) has more 2024 works (4 against 3), but many are co-authored with other institutions. Kesting has fewer works, but its shares are larger because A09 and A10 are both Kesting and W22 is single-author, so it wins on fractional counting (2.0 against 1.0).
Why: Gets Kesting's larger shares (single-author W22, A09 and A10 both Kesting) but never says Rostval's works have four authors with one from Rostval, so a quarter each; it only says 'many are co-authored'.
sparql run 2
(no answer found)
Why: No answer was given, so neither checklist point is met
sparql run 3
Rostval has more works in total (4 against 3). It shares most of them with other institutions, so its fractional total is 1.0. Kesting's W22 is wholly its own and it holds half of W20 and W21, giving 2.0.
Why: Correctly says Kesting holds W22 wholly and half of W20 and W21, but misses that each Rostval work has four authors with one from Rostval (a quarter each); only 'shares most' is vague.
sparql run 4
Rostval has more works (4 against 3), but each is shared among four authors at different institutions, so its fractional total is only 1.0. Kesting's works have more authors at Kesting itself, giving it 2.0.
Why: Correctly says Rostval's works are shared among four authors at different institutions, but doesn't state one author each from Rostval giving a quarter share, and it misattributes Kesting's lead (omits the single-author review W22 and half shares of W20 and W21, claiming only 'more authors at Kesting').
sparql run 5
Rostval has more 2024 works (4 against 3), but they are multi-institution papers on which its author is one of four. Kesting has the larger share (2.0 against 1.0), so the two swap places.
Why: Gives Kesting's larger share but omits the four-authors/quarter-each detail and the W22/W20/W21 breakdown; the 'one of four' is stated but not the quarter share
sparql+ontology run 1
Full counting gives each work to every institution credited on it, so Rostval wins with 4 works against Kesting's 3. Under fractional counting Rostval only gets a quarter share of each of its works, because they have four authors from different institutions. Kesting keeps whole or half shares, so it wins 2.0 to 1.0.
sparql+ontology run 2
Under full counting Rostval has 4 works (W21, W27, W28, W29) against Kesting's 3. Each Rostval work has four authors, so Rostval gets only 0.25 per work (1.0 in total), while Kesting gets 2.0 from W20 (0.5), W21 (0.5) and W22 (1.0).
sparql+ontology run 3
(no answer found)
Why: No answer given; meets none of the checklist points
sparql+ontology run 4
In 2024 Rostval has more works in total (4 against 3), but they are spread across 4-author bylines, so each yields only a 0.25 share. Kesting's works have fewer authors and keep larger shares (2.0 against 1.0).
sparql+ontology run 5
Rostval has more works in total, but each has only one Rostval author out of four, so its fractional share is 1.0. Kesting has fewer works but larger author shares, giving 2.0.
Why: Gets Rostval's quarter shares, but omits Kesting's specifics (single-author W22, half of W20 and W21), saying only 'larger author shares'.