Q12, run 2026-11-04-1738-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-, from A34, the initial rating on 2023-01-15.
JSON: {"rating": "A-"}
sql run 2
A-. A34 is E14's rating from 2023-01-15.
JSON: {"rating": "A-"}
sql run 3
A-, from A34.
JSON: {"rating": "A-"}
sql run 4
A-, from A34 (2023-01-15).
JSON: {"rating": "A-"}
sql run 5
A-, from A34.
JSON: {"rating": "A-"}
sql+markdown run 1
A-. A34 assigned A- on 2023-01-15, before the downgrade.
JSON: {"rating": "A-"}
sql+markdown run 2
A-. This is A34 (2023-01-15), before any later action.
JSON: {"rating": "A-"}
sql+markdown run 3
A-, from A34 (2023-01-15).
JSON: {"rating": "A-"}
sql+markdown run 4
A-. A34 set it on 2023-01-15, before the A36 downgrade.
JSON: {"rating": "A-"}
sql+markdown run 5
A-. This is the rating from A34 (2023-01-15), before the downgrade.
JSON: {"rating": "A-"}
sparql run 1
A- (A34).
JSON: {"rating": "A-"}
sparql run 2
A-, from A34.
JSON: {"rating": "A-"}
sparql run 3
A-, from A34.
JSON: {"rating": "A-"}
sparql run 4
A-. A34 set E14 at A- on 2023-01-15, before the 2024 downgrade.
JSON: {"rating": "A-"}
sparql run 5
A-. E14 held A- from A34 (2023-01-15) until A36.
JSON: {"rating": "A-"}
sparql+ontology run 1
A-, from A34 (assigned 2023-01-15).
JSON: {"rating": "A-"}
sparql+ontology run 2
A-, from A34 (2023-01-15).
JSON: {"rating": "A-"}
sparql+ontology run 3
A-, from A34 (2023-01-15).
JSON: {"rating": "A-"}
sparql+ontology run 4
A-, as assigned on 2023-01-15 (A34).
JSON: {"rating": "A-"}
sparql+ontology run 5
A-, from A34.
JSON: {"rating": "A-"}