Q39, run 2026-11-05-1515-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. E02 is rated A (A08), and E03's A (A09, Positive outlook) is the same entity.
JSON: {"rating": "A"}
sql run 2
A (A08/A09).
JSON: {"rating": "A"}
sql run 3
A. A09 affirmed A on 2025-09-15, after A08 assigned A.
JSON: {"rating": "A"}
sql run 4
A. E02 is still at A with no later change.
JSON: {"rating": "A"}
sql run 5
A, with a positive outlook.
JSON: {"rating": "A"}
sql+markdown run 1
A.
JSON: {"rating": "A"}
sql+markdown run 2
A, per A09 on E03 (same LEI as E02).
JSON: {"rating": "A"}
sql+markdown run 3
A (A09).
JSON: {"rating": "A"}
sql+markdown run 4
A, from A08 and A09. The Positive outlook does not change the rating.
JSON: {"rating": "A"}
sql+markdown run 5
A (A09, for the merged E02/E03 entity).
JSON: {"rating": "A"}
sparql run 1
A, per the E02/E03 records (same LEI). The latest action is A09 on 2025-09-15, an affirmation of A.
JSON: {"rating": "A"}
sparql run 2
A, from E03's A09 on 2025-09-15, which is later than E02's A (A08).
JSON: {"rating": "A"}
sparql run 3
A- (A08).
JSON: {"rating": "A-"}
Why: rating: expected A, got A-
sparql run 4
A (A08/A09, same LEI).
JSON: {"rating": "A"}
sparql run 5
A. E02 and E03 are the same entity, and the latest rating is A.
JSON: {"rating": "A"}
sparql+ontology run 1
A. The E02 and E03 records agree on A.
JSON: {"rating": "A"}
sparql+ontology run 2
A. This is the same record chain as Q4.
JSON: {"rating": "A"}
sparql+ontology run 3
A (A09).
JSON: {"rating": "A"}
sparql+ontology run 4
A, with a Positive outlook (A09).
JSON: {"rating": "A"}
sparql+ontology run 5
A (A08, A09).
JSON: {"rating": "A"}
sql+executed run 1
A.
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. This is E02's current LTIDR.
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"}