Q9, run 2026-11-06-0519-sonnet-query
How many research works is the University of Albury (I02) credited with, its units included?
Tests: Hierarchy: the labs' works count, each work once; also versions, types, the affiliation rule and the affiliated institute.
Expected: count = 95
sql run 1
119.
JSON: {"count": 119}
Why: count: expected 95, got 119
sql run 2
106. This counts research works (ART or REV, not retracted) and includes I03, I04 and I19. I did not roll up the affiliate I06.
JSON: {"count": 106}
Why: count: expected 95, got 106
sql run 3
118.
JSON: {"count": 118}
Why: count: expected 95, got 118
sql run 4
117.
JSON: {"count": 117}
Why: count: expected 95, got 117
sql run 5
118. This counts ART and REV works with any I02-or-descendant affiliation, retractions included.
JSON: {"count": 118}
Why: count: expected 95, got 118
sql+markdown run 1
95.
JSON: {"count": 95}
sql+markdown run 2
65.
JSON: {"count": 65}
Why: count: expected 95, got 65
sql+markdown run 3
65.
JSON: {"count": 65}
Why: count: expected 95, got 65
sql+markdown run 4
111.
JSON: {"count": 111}
Why: count: expected 95, got 111
sql+markdown run 5
95.
JSON: {"count": 95}
sql+executed run 1
95.
JSON: {"count": 95}
sql+executed run 2
95.
JSON: {"count": 95}
sql+executed run 3
95.
JSON: {"count": 95}
sql+executed run 4
95.
JSON: {"count": 95}
sql+executed run 5
95 research works.
JSON: {"count": 95}
sparql run 1
116, from 103 ART and 13 REV that are not retracted. Preprints are assumed to merge with their published versions.
JSON: {"count": 116}
Why: count: expected 95, got 116
sparql run 2
(no answer found)
JSON: {"count": 141}
Why: count: expected 95, got 141
sparql run 3
117, counting works by units under I02 and merging preprints into their published versions. This count includes I06, which is typed as an affiliate (itype-AFF) and may not be a true unit.
JSON: {"count": 117}
Why: count: expected 95, got 117
sparql run 4
116, for I02 with its units.
JSON: {"count": 116}
Why: count: expected 95, got 116
sparql run 5
116, summed from the per-year counts for I02.
JSON: {"count": 116}
Why: count: expected 95, got 116
sparql+ontology run 1
53, summing the per-year counts for I02 (2019–2025).
JSON: {"count": 53}
Why: count: expected 95, got 53
sparql+ontology run 2
95.
JSON: {"count": 95}
sparql+ontology run 3
95. I06 is an affiliated institute (AFF) and is excluded.
JSON: {"count": 95}
sparql+ontology run 4
95. This is the sum of the per-year counts for I02.
JSON: {"count": 95}
sparql+ontology run 5
95. This is the sum of the yearly counts credited to I02.
JSON: {"count": 95}