Q15, run 2026-11-06-0935-sonnet-query
What was Halden Bank's rating on 1 January 2026?
Tests: Time: the downgrade came later in 2026.
Expected: rating = A-
sql run 1
A-. A26 assigned it in 2023, and the downgrade to BBB+ (A27) came on 2026-04-15, after this date.
JSON: {"rating": "A-"}
sql run 2
A-. The downgrade to BBB+ (A27) came on 2026-04-15, after that date.
JSON: {"rating": "A-"}
sql run 3
A-. This is E10's rating (A26). E17 is a duplicate record, and the downgrade A27 came later, in April 2026.
JSON: {"rating": "A-"}
sql run 4
A-, from A26. The downgrade A27 came on 2026-04-15.
JSON: {"rating": "A-"}
sql run 5
A-. E10 held A- from A26 until the downgrade on 2026-04-15, and E17 is a duplicate of E10.
JSON: {"rating": "A-"}
sql+markdown run 1
A-. The E10 downgrade A27 did not happen until 2026-04-15.
JSON: {"rating": "A-"}
sql+markdown run 2
A-. A26 set E10's rating (the same entity as E17), and the downgrade A27 came on 2026-04-15.
JSON: {"rating": "A-"}
sql+markdown run 3
A-. A26 set it, and the downgrade A27 came on 2026-04-15.
JSON: {"rating": "A-"}
sql+markdown run 4
A- (A26). The downgrade to BBB+ came on 2026-04-15.
JSON: {"rating": "A-"}
sql+markdown run 5
A-. E10 (also recorded as E17) held A- from A26 until the downgrade A27 on 2026-04-15.
JSON: {"rating": "A-"}
sparql run 1
A-, from A26 for E10. E17 is the same entity and has no actions of its own.
JSON: {"rating": "A-"}
sparql run 2
A-. This is E10's rating from A26 (2023-05-01); the downgrade to BBB+ (A27) came on 2026-04-15.
JSON: {"rating": "A-"}
sparql run 3
A-. This is from A26. E17 is a duplicate record with no ratings.
JSON: {"rating": "A-"}
sparql run 4
A- (A26). The downgrade A27 came on 2026-04-15, and E17 is a duplicate of E10 with no ratings.
JSON: {"rating": "A-"}
sparql run 5
A-. This is E10's rating from A26, before the 2026-04-15 downgrade (A27). E17 is a duplicate record.
JSON: {"rating": "A-"}
sparql+ontology run 1
A-. A26 still held on 2026-01-01; A27 came on 2026-04-15.
JSON: {"rating": "A-"}
sparql+ontology run 2
A-. E10 held A- (A26) until the downgrade A27 on 2026-04-15.
JSON: {"rating": "A-"}
sparql+ontology run 3
A-. E10's rating was A- (A26) until A27 on 2026-04-15.
JSON: {"rating": "A-"}
sparql+ontology run 4
A-. A26 was still in force, because the downgrade A27 came on 2026-04-15.
JSON: {"rating": "A-"}
sparql+ontology run 5
A-. E10 and E17 are the same entity, and A26 held until the downgrade in A27 on 2026-04-15.
JSON: {"rating": "A-"}
sql+executed run 1
A- (A26, in force until 2026-04-15).
JSON: {"rating": "A-"}
sql+executed run 2
A-. E10 held A- until 2026-04-15 (A26).
JSON: {"rating": "A-"}
sql+executed run 3
A- (E10, A26).
JSON: {"rating": "A-"}
sql+executed run 4
A- (A26).
JSON: {"rating": "A-"}
sql+executed run 5
A-. E10 (which merges E17) was A- on 2026-01-01 (A26).
JSON: {"rating": "A-"}
sparql+axioms run 1
A-. Halden Bank (E10) held A- until 2026-04-15 (A26).
JSON: {"rating": "A-"}
sparql+axioms run 2
A- (A26).
JSON: {"rating": "A-"}
sparql+axioms run 3
A-. Halden Bank (E10, same entity as E17) was rated A- (A26) until 2026-04-15.
JSON: {"rating": "A-"}
sparql+axioms run 4
A- (A26, E10).
JSON: {"rating": "A-"}
sparql+axioms run 5
A- (A26, Halden Bank, E10).
JSON: {"rating": "A-"}