Q9, run 2026-11-06-0808-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 = 8
sql run 1
12: W01, W03, W06, W07, W12, W13, W19, W70, W71, W72, W73, W74.
JSON: {"count": 12}
Why: count: expected 8, got 12
sql run 2
12 (W01, W03, W06, W07, W12, W13, W19, W70, W71, W72, W73, W74).
JSON: {"count": 12}
Why: count: expected 8, got 12
sql run 3
12: W01, W03, W06, W07, W12, W13, W19, W70, W71, W72, W73, W74, with units I03, I04 and I06 included.
JSON: {"count": 12}
Why: count: expected 8, got 12
sql run 4
12 (W01, W03, W06, W07, W12, W13, W19, W70, W71, W72, W73, W74). I counted research output as ART, REV and standalone preprints. I left out editorials (EDT), errata (ERR), front matter (PTX), supplements (SUP), preprints that are versions of another work, and records from the STG (staging) source.
JSON: {"count": 12}
Why: count: expected 8, got 12
sql run 5
12: W01, W02/W03, W06, W07, W12, W13, W19, W70, W71, W72, W73, W74.
JSON: {"count": 12}
Why: count: expected 8, got 12
sql+markdown run 1
8. The works are W01, W03 (with W02), W06, W12, W13, W19, W71 and W72. W70 is excluded because its last-listed affiliation is I06, an affiliated institute. W73 and W74 are I06 only.
JSON: {"count": 8}
sql+markdown run 2
8: W01, W03, W06, W12, W13, W19, W71, W72. W70 is credited to I06 instead, and I06 is an affiliated institute.
JSON: {"count": 8}
sql+markdown run 3
8: W01, W03 (with W02), W06, W12, W13, W19, W71, W72. W70 and W73 are credited to I06, which is an affiliated institute and not a unit.
JSON: {"count": 8}
sql+markdown run 4
8: W01, W03, W06, W12, W13, W19, W71, W72.
JSON: {"count": 8}
sql+markdown run 5
8.
JSON: {"count": 8}
sql+executed run 1
8. They are W01, W03, W06, W12, W13, W19, W71 and W72, credited to I02, I03 or I04.
JSON: {"count": 8}
sql+executed run 2
8. The works are W01, W03, W06, W12, W13, W19, W71 and W72, credited to I02, I03 or I04.
JSON: {"count": 8}
sql+executed run 3
8. They are W01, W03, W06, W12, W13, W19, W71 and W72; I06 does not roll up into I02 in `institution_units`.
JSON: {"count": 8}
sql+executed run 4
8. They are W01, W03, W06, W12, W13, W19, W71 and W72, credited to I02, I03 or I04.
JSON: {"count": 8}
sql+executed run 5
8 (W01, W03, W06, W12, W13, W19, W71, W72), counting I02, I03 and I04.
JSON: {"count": 8}
sparql run 1
12. These are W01, W03, W06, W07, W12, W13, W19, W70, W71, W72, W73 and W74.
JSON: {"count": 12}
Why: count: expected 8, got 12
sparql run 2
(no answer found)
Why: no structured answer
sparql run 3
12: W01, W03, W06, W07, W12, W13, W19, W70, W71, W72, W73, W74.
JSON: {"count": 12}
Why: count: expected 8, got 12
sparql run 4
12: W01, W03 (with W02), W06, W07, W12, W13, W19, W70, W71, W72, W73, W74.
JSON: {"count": 12}
Why: count: expected 8, got 12
sparql run 5
12: W01, W02/W03, W06, W07, W12, W13, W19, W70, W71, W72, W73, W74. Units are I03, I04 and I06.
JSON: {"count": 12}
Why: count: expected 8, got 12
sparql+ontology run 1
8: W01, W03 (with its preprint W02), W06, W12, W13, W19, W71, W72. W70 is credited to I06, which is an affiliated institute.
JSON: {"count": 8}
sparql+ontology run 2
8. These are W01, W03, W06, W12, W13, W19, W71 and W72. W70 and W73 are credited to the affiliated institute I06, which is not a unit of I02.
JSON: {"count": 8}
sparql+ontology run 3
(no answer found)
JSON: {"count": null}
Why: count: expected 8, got None
sparql+ontology run 4
8. They are W01, W03, W06, W12, W13, W19, W71 and W72; W70 is credited to the affiliated institute I06, which does not roll up.
JSON: {"count": 8}
sparql+ontology run 5
8: W01, W03, W06, W12, W13, W19, W71, W72. I06 is an affiliated institute, so W70, W73 and W74 are not credited upward to I02.
JSON: {"count": 8}