Q39, run 2026-11-06-0935-sonnet-query
What is Northwind Holdings' current rating?
Tests: Identity: the latest action sits on the other record.
Expected: rating = A
sql run 1
A. A08 assigned it, A09 affirmed it, and there has been no change since.
JSON: {"rating": "A"}
sql run 2
A (A09 and A08).
JSON: {"rating": "A"}
sql run 3
A, from A08 and A09.
JSON: {"rating": "A"}
sql run 4
A, from A08 and the A09 affirmation under the same LEI.
JSON: {"rating": "A"}
sql run 5
A. E02 was assigned A in A08 and affirmed at A via E03 in A09.
JSON: {"rating": "A"}
sql+markdown run 1
A, from A09.
JSON: {"rating": "A"}
sql+markdown run 2
A (A09).
JSON: {"rating": "A"}
sql+markdown run 3
A.
JSON: {"rating": "A"}
sql+markdown run 4
A (A08, A09).
JSON: {"rating": "A"}
sql+markdown run 5
A, from A09.
JSON: {"rating": "A"}
sparql run 1
A. The rating is unchanged since A08, affirmed in A09.
JSON: {"rating": "A"}
sparql run 2
A, from A09 (E03, the same entity as E02).
JSON: {"rating": "A"}
sparql run 3
A (A08/A09).
JSON: {"rating": "A"}
sparql run 4
A, per A08/A09.
JSON: {"rating": "A"}
sparql run 5
A. Both E02 and E03 show A, and E03's latest action is an affirmation (A09).
JSON: {"rating": "A"}
sparql+ontology run 1
A, from A09 (E03 and E02 are the same entity).
JSON: {"rating": "A"}
sparql+ontology run 2
A.
JSON: {"rating": "A"}
sparql+ontology run 3
A. This follows A09 on E03, which is the same entity as E02.
JSON: {"rating": "A"}
sparql+ontology run 4
A.
JSON: {"rating": "A"}
sparql+ontology run 5
A.
JSON: {"rating": "A"}
sql+executed run 1
A (A09).
JSON: {"rating": "A"}
sql+executed run 2
A (A09).
JSON: {"rating": "A"}
sql+executed run 3
A (A09).
JSON: {"rating": "A"}
sql+executed run 4
A (A09).
JSON: {"rating": "A"}
sql+executed run 5
A (A09).
JSON: {"rating": "A"}
sparql+axioms run 1
A (A09).
JSON: {"rating": "A"}
sparql+axioms run 2
A (A09).
JSON: {"rating": "A"}
sparql+axioms run 3
A (A09).
JSON: {"rating": "A"}
sparql+axioms run 4
A (A09).
JSON: {"rating": "A"}
sparql+axioms run 5
A (A09).
JSON: {"rating": "A"}