Q11, run 2026-11-06-0808-sonnet-query
How many research works is Kesting University (I07) credited with, its units included?
Tests: Hierarchy with retraction and test records: the institute's W24 counts; W23 (retracted) and W90 to W92 (STG) don't.
Expected: count = 6
sql run 1
9: W08, W16, W20, W21, W22, W23, W90, W91, W92. This includes retracted W23 and the STG-sourced W90–W92.
JSON: {"count": 9}
Why: count: expected 6, got 9
sql run 2
6 (W08, W16, W20, W21, W22, W23).
JSON: {"count": 6}
sql run 3
6: W08, W16, W20, W21, W22, W23 (I07 and I08). I excluded W24 (supplement type) and W90–92 (record_source STG, which I treated as unvetted staging records).
JSON: {"count": 6}
sql run 4
6 (W08, W16, W20, W21, W22, W23). W24 is a supplement and W90–92 are STG records.
JSON: {"count": 6}
sql run 5
9: W08, W16, W20, W21, W22, W23, W90, W91, W92. I counted retracted W23 and the STG-sourced W90–W92 as research works, since the data does not exclude them.
JSON: {"count": 9}
Why: count: expected 6, got 9
sql+markdown run 1
6. They are W08, W16, W20, W21, W22 and W24. W23 is retracted and W90–92 are staging records.
JSON: {"count": 6}
sql+markdown run 2
6: W08, W16, W20, W21, W22, W24. W23 is retracted and W90–W92 are staging records.
JSON: {"count": 6}
sql+markdown run 3
6: W08, W16, W20, W21, W22, W24. W23 is retracted, and W90–W92 are staging records.
JSON: {"count": 6}
sql+markdown run 4
6: W08, W16, W20, W21, W22, W24. W23 is retracted and W90–W92 are staging records.
JSON: {"count": 6}
sql+markdown run 5
6.
JSON: {"count": 6}
sql+executed run 1
6. They are W08, W16, W20, W21, W22 and W24, credited to I07 or I08. W23 is excluded because it is retracted.
JSON: {"count": 6}
sql+executed run 2
6. The works are W08, W16, W20, W21, W22 and W24; W23 is excluded because it is retracted and not research output.
JSON: {"count": 6}
sql+executed run 3
6. They are W08, W16, W20, W21, W22 and W24; W23 is retracted and not research output.
JSON: {"count": 6}
sql+executed run 4
6. These are W08, W16, W20, W21, W22 (I07) and W24 (I08). W23 is excluded because it is not research output.
JSON: {"count": 6}
sql+executed run 5
6 (W08, W16, W20, W21, W22, W24). W23 is excluded because it is retracted and not research output.
JSON: {"count": 6}
sparql run 1
9. These are W08, W16, W20, W21, W22, W23, W90, W91 and W92. I counted the staging records (W90–W92) and the retracted W23.
JSON: {"count": 9}
Why: count: expected 6, got 9
sparql run 2
(no answer found)
Why: no structured answer
sparql run 3
9: W08, W16, W20, W21, W22, W23, W90, W91, W92. W24 is a supplement and is excluded.
JSON: {"count": 9}
Why: count: expected 6, got 9
sparql run 4
9: W08, W16, W20, W21, W22, W23, W90, W91, W92. I included the retracted W23, and W90–W92 even though their record source is STG (staging). W24 is excluded as supplementary material.
JSON: {"count": 9}
Why: count: expected 6, got 9
sparql run 5
8: W08, W16, W20, W21, W22, W90, W91, W92. W23 is excluded because it is retracted and W24 because it is supplementary material. W90–W92 have STG record sources, which I counted; the data does not say they should be excluded.
JSON: {"count": 8}
Why: count: expected 6, got 8
sparql+ontology run 1
6: W08, W16, W20, W21, W22, W24. W23 is retracted and W90–W92 are staging records.
JSON: {"count": 6}
sparql+ontology run 2
6. These are W08, W16, W20, W21, W22 and W24. W23 is retracted and W90–W92 are staging records.
JSON: {"count": 6}
sparql+ontology run 3
(no answer found)
JSON: {"count": null}
Why: count: expected 6, got None
sparql+ontology run 4
6. They are W08, W16, W20, W21, W22 and W24; the retracted W23 and the staging records are excluded.
JSON: {"count": 6}
sparql+ontology run 5
6: W08, W16, W20, W21, W22, W24. W23 is retracted and W90–92 are staging records.
JSON: {"count": 6}