Q6, run 2026-11-06-0519-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 (ORCID 0000-0002-9841-6229) has 23 distinct research works credited to I02 and its units, more than anyone else.
JSON: {"author": "A01"}
sql run 2
Mara Ellison (A01), with 22 research works credited to I02 or its units.
JSON: {"author": "A01"}
sql run 3
A01, with 23 research works credited to I02 and its units.
JSON: {"author": "A01"}
sql run 4
A01 (Mara Ellison), with 22 research works; the next author has 15.
JSON: {"author": "A01"}
sql run 5
A01 (Mara Ellison). Her 23 research works are all credited to I02, ahead of A07 with 15.
JSON: {"author": "A01"}
sql+markdown run 1
A01, with 19 research works credited to I02 and its units. The next highest is A07 with 15.
JSON: {"author": "A01"}
sql+markdown run 2
A01. This person (ORCID 0002-9841-6229) has 19 research works credited to the University of Albury and its units, the most of any author.
JSON: {"author": "A01"}
sql+markdown run 3
A01 (Mara Ellison), but she ties with A07 (Priya Ramanathan). Each has 5 research works credited to I02 and its units (W01, W09, W10, W11, W12), and the data does not break the tie; A01 is my pick.
JSON: {"author": "A01"}
sql+markdown run 4
A01. The person with ORCID 0000-0002-9841-6229 has 19 research works credited to I02 and its units, the most of anyone.
JSON: {"author": "A01"}
sql+markdown run 5
A01, with 19 research works credited to I02 and its units.
JSON: {"author": "A01"}
sql+executed run 1
A01, with 19 research works credited to I02 and its units.
JSON: {"author": "A01"}
sql+executed run 2
A01, with 19 research works credited to I02 and its units.
JSON: {"author": "A01"}
sql+executed run 3
A01, with 19 research works credited to I02 and its units.
JSON: {"author": "A01"}
sql+executed run 4
A01, with 19 research works credited to I02 and its units (A07 has 15).
JSON: {"author": "A01"}
sql+executed run 5
A01, with 19 research works credited to I02 and its units.
JSON: {"author": "A01"}
sparql run 1
A01, the Mara Ellison person (A01/A02/A03/A101), with 23 ART/REV works credited to I02 or its units. The next is A07 with 15.
JSON: {"author": "A01"}
sparql run 2
A01, with 23 research works at I02 and its units.
JSON: {"author": "A01"}
sparql run 3
A110, tied with A07 at 15 by record. I picked A110 on the assumption that merging its aliases by ORCID would push it ahead, but I did not check this.
JSON: {"author": "A110"}
Why: author: expected A01, got A110
sparql run 4
A01, Mara Ellison. Her ORCID has 22 Albury research works, the most of any author; A07 is next with 15.
JSON: {"author": "A01"}
sparql run 5
Unresolved.
JSON: {"author": null}
Why: author: expected A01, got None
sparql+ontology run 1
A01, the record for Mara Ellison's ORCID, which has the most I02 works (19).
JSON: {"author": "A01"}
sparql+ontology run 2
A01, with 19 research works credited to I02, units included.
JSON: {"author": "A01"}
sparql+ontology run 3
A01. Her ORCID has 19 research works credited to I02 and its units (I03, I04, I19), the most of any person. The next is 15.
JSON: {"author": "A01"}
sparql+ontology run 4
A01 (Mara Ellison, ORCID …9841), with 19 research works credited to I02.
JSON: {"author": "A01"}
sparql+ontology run 5
A01, Mara Ellison, with 19 research works credited to I02. The next is Priya Ramanathan with 15.
JSON: {"author": "A01"}