Q39, run 2026-11-06-0041-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).
JSON: {"rating": "A"}
sql run 2
A (A08, A09).
JSON: {"rating": "A"}
sql run 3
A. E02 and E03 are the same entity, and the latest action (A09) is an affirmation at A.
JSON: {"rating": "A"}
sql run 4
A, from A08 and A09.
JSON: {"rating": "A"}
sql run 5
A, from A09 (E03, the duplicate of E02).
JSON: {"rating": "A"}
sql+markdown run 1
A. Both E02 (A08) and E03 (A09) are A.
JSON: {"rating": "A"}
sql+markdown run 2
A.
JSON: {"rating": "A"}
sql+markdown run 3
A. E02 was assigned A (A08) and later affirmed at A (A09).
JSON: {"rating": "A"}
sql+markdown run 4
A. The latest action is A09 for the same entity (E03), an affirmation at A.
JSON: {"rating": "A"}
sql+markdown run 5
A, from A08 and A09.
JSON: {"rating": "A"}
sparql run 1
A, affirmed in A09.
JSON: {"rating": "A"}
sparql run 2
A, from A09 and the earlier A08.
JSON: {"rating": "A"}
sparql run 3
A (A09).
JSON: {"rating": "A"}
sparql run 4
A, assuming the latest action is the E03 affirmation (A09, 2025-09-15).
JSON: {"rating": "A"}
sparql run 5
A (A09).
JSON: {"rating": "A"}
sparql+ontology run 1
A. The latest action on E02/E03 is A09.
JSON: {"rating": "A"}
sparql+ontology run 2
A (A09 on E03, same entity as E02).
JSON: {"rating": "A"}
sparql+ontology run 3
A, from A09.
JSON: {"rating": "A"}
sparql+ontology run 4
A (A09).
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 on E03, which is the same entity as E02).
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, per A09 on E03 (the same entity as E02).
JSON: {"rating": "A"}
sparql+axioms run 5
A (A09).
JSON: {"rating": "A"}