Q6, run 2026-11-06-0808-sonnet-query
Which author has the most research works credited to the University of Albury, its units included?
Tests: Identity: Mara Ellison's five works are split over three records; by record, Priya Ramanathan (four) would come first.
Expected: author = A01
sql run 1
A01 (Mara, via A01/A02/A03) has 6 research works: W01, W03, W06, W07, W12, W19. A07 and A08 have 4 each.
JSON: {"author": "A01"}
sql run 2
A01, with 6 Albury research works (W01, W03, W06, W07, W12, W19). A07 and A08 have 4 each.
JSON: {"author": "A01"}
sql run 3
A01, with 6 works: W01, W03, W06, W07, W12, W19. A07 and A08 each have 4.
JSON: {"author": "A01"}
sql run 4
A01. She has 6 research works credited to I02 and its units (W01, W03, W06, W07, W12, W19). A08 has 4 and A07 has 4.
JSON: {"author": "A01"}
sql run 5
A01, the Mara Ellison person, with 6 works (W01, W02/W03 counted once, W06, W07, W12, W19). A07 and A08 have 4 each.
JSON: {"author": "A01"}
sql+markdown run 1
A01. Mara Ellison has 5 research works credited to Albury (W01, W03, W06, W12, W19). A07 has 4 and A08 has 2.
JSON: {"author": "A01"}
sql+markdown run 2
A01 (Mara Ellison) has 5 research works credited to the University of Albury: W01, W03 (with its preprint W02), W06, W12, W19. The next is A07 with 4.
JSON: {"author": "A01"}
sql+markdown run 3
A01 (Mara Ellison). Her records cover W01, W03 (with W02), W06, W12 and W19, which is 5 research works.
JSON: {"author": "A01"}
sql+markdown run 4
A01 (Mara Ellison), with 5 research works: W01, W03 (with its preprint W02), W06, W12 and W19. A07 has 4 and A08 has 2.
JSON: {"author": "A01"}
sql+markdown run 5
A01. Mara Ellison has 5 research works credited to I02, ahead of A07 with 4 and A08 with 2.
JSON: {"author": "A01"}
sql+executed run 1
A01. She has 5 research works at the University of Albury (W01, W03, W06, W12, W19), against 4 each for A07 and A08.
JSON: {"author": "A01"}
sql+executed run 2
A01. For the University of Albury, units included, A01 has 5 research works (W01, W03, W06, W12, W19), ahead of A07 with 4 and A08 with 2.
JSON: {"author": "A01"}
sql+executed run 3
A01. A01 has 5 research works credited to I02/I03/I04 (W01, W03, W06, W12, W19), against 4 for A07 and 2 for A08.
JSON: {"author": "A01"}
sql+executed run 4
A01. Counting I02, I03 and I04, A01 has 5 research works (W01, W03, W06, W12, W19), A07 has 4 and A08 has 2. I06 does not roll up into I02.
JSON: {"author": "A01"}
sql+executed run 5
A01. A01 has 5 research works credited to I02 or its units (W01, W03, W06, W12, W19), against 4 for A07 and 2 for A08.
JSON: {"author": "A01"}
sparql run 1
A01 (Mara Ellison), with 6 research works. The University of Albury's units are I03, I04 and I06. Her works are W01, W03 (W02 is its preprint), W06, W07, W12 and W19. A07 and A08 each have 4.
JSON: {"author": "A01"}
sparql run 2
(no answer found)
Why: no structured answer
sparql run 3
Mara Ellison (A01/A02/A03) has 6 research works credited to I02 and its units: W01, W03, W06, W07, W12, W19. A07 has 4 and A08 has 4.
JSON: {"author": "A01"}
sparql run 4
A01 (Mara Ellison) has the most, 6 works: W01, W03 (with its preprint W02), W06, W07, W12 and W19. The next highest are A07 with 4 and A08 with 4.
JSON: {"author": "A01"}
sparql run 5
A01 (Mara Ellison, merged with A02 and A03). She has 6 research works credited to I02 or its units. A07 and A08 have 4 each.
JSON: {"author": "A01"}
sparql+ontology run 1
A01 (Mara Ellison), with 5 research works: W01, W03, W06, W12, W19. A07 has 4 and A08 has 2.
JSON: {"author": "A01"}
sparql+ontology run 2
A01. Mara has 5 research works credited to I02 and its units (W01, W03, W06, W12, W19), against 4 for A07 and 2 for A08.
JSON: {"author": "A01"}
sparql+ontology run 3
(no answer found)
JSON: {"author": null}
Why: author: expected A01, got None
sparql+ontology run 4
A01. She has 5 research works credited to Albury: W01, W03 (with W02), W06, W12 and W19. A07 has 4.
JSON: {"author": "A01"}
sparql+ontology run 5
A01. Mara Ellison has W01, W03 (with its preprint W02), W06, W12 and W19, which is 5 and more than anyone else (A07 has 4).
JSON: {"author": "A01"}