Q12, run 2026-11-05-1515-sonnet-query
What was Marlow Utilities' rating on 1 January 2024?
Tests: Time: the rating on a date before a later downgrade.
Expected: rating = A-
sql run 1
A-. This is E14's initial rating A34.
JSON: {"rating": "A-"}
sql run 2
A-, from A34.
JSON: {"rating": "A-"}
sql run 3
A-. This is from A34 (2023-01-15).
JSON: {"rating": "A-"}
sql run 4
A- (A34).
JSON: {"rating": "A-"}
sql run 5
A- (A34).
JSON: {"rating": "A-"}
sql+markdown run 1
A-, from A34 (assigned 2023-01-15).
JSON: {"rating": "A-"}
sql+markdown run 2
A-. A34 assigned A- on 2023-01-15, and no change came before 2024-01-01.
JSON: {"rating": "A-"}
sql+markdown run 3
A-. A34 (2023-01-15) set it and A36 did not follow until 2024-09-30.
JSON: {"rating": "A-"}
sql+markdown run 4
A-, set by A34 on 2023-01-15.
JSON: {"rating": "A-"}
sql+markdown run 5
A-. This is A34, since the downgrade came later.
JSON: {"rating": "A-"}
sparql run 1
A-. Marlow was A- from 2023-01-15 (A34) until the 2024-09-30 downgrade.
JSON: {"rating": "A-"}
sparql run 2
A-. This is E14's A-AS rating from 2023-01-15 (A34).
JSON: {"rating": "A-"}
sparql run 3
None. E13's first rating is dated 2024-06-01 (A22).
JSON: {"rating": "none"}
Why: rating: expected A-, got none
sparql run 4
A-, from A34 (2023-01-15).
JSON: {"rating": "A-"}
sparql run 5
A-. E14 was rated A- from 2023-01-15 (A34).
JSON: {"rating": "A-"}
sparql+ontology run 1
A-. This is E14's 2023-01-15 assignment, before the 2024-09-30 downgrade.
JSON: {"rating": "A-"}
sparql+ontology run 2
A-. E14 was assigned A- on 2023-01-15.
JSON: {"rating": "A-"}
sparql+ontology run 3
A-. It was assigned on 2023-01-15 (A34).
JSON: {"rating": "A-"}
sparql+ontology run 4
A-, set by A34.
JSON: {"rating": "A-"}
sparql+ontology run 5
A-. This was set on 2023-01-15 (E14).
JSON: {"rating": "A-"}
sql+executed run 1
A- (A34).
JSON: {"rating": "A-"}
sql+executed run 2
A-. Marlow's rating on 2024-01-01 was A- (A34).
JSON: {"rating": "A-"}
sql+executed run 3
A-. This was E14's rating from 2023-01-15 (A34).
JSON: {"rating": "A-"}
sql+executed run 4
A-. E14 held A- from 2023-01-15 to 2024-09-30 (A34).
JSON: {"rating": "A-"}
sql+executed run 5
A- (A34).
JSON: {"rating": "A-"}
sparql+axioms run 1
A- (A34).
JSON: {"rating": "A-"}
sparql+axioms run 2
A- (A34).
JSON: {"rating": "A-"}
sparql+axioms run 3
A- (A34).
JSON: {"rating": "A-"}
sparql+axioms run 4
A- (A34).
JSON: {"rating": "A-"}
sparql+axioms run 5
A- (A34).
JSON: {"rating": "A-"}