Q13, run 2026-11-05-1515-sonnet-query
How many times has Marlow Utilities been downgraded?
Tests: Action types over time: a Watch placement and an affirmation are not downgrades.
Expected: count = 1
sql run 1
1. Only A36 is a downgrade for E14.
JSON: {"count": 1}
sql run 2
1. Only A36 is a downgrade; A35 is a watch placement.
JSON: {"count": 1}
sql run 3
1. The only downgrade of E14 is A36.
JSON: {"count": 1}
sql run 4
1, for E14 (A36).
JSON: {"count": 1}
sql run 5
1, from A36.
JSON: {"count": 1}
sql+markdown run 1
1, the downgrade A36.
JSON: {"count": 1}
sql+markdown run 2
1. The only downgrade is A36.
JSON: {"count": 1}
sql+markdown run 3
1. The only downgrade is A36.
JSON: {"count": 1}
sql+markdown run 4
1. The only downgrade of E14 is A36.
JSON: {"count": 1}
sql+markdown run 5
1. The only downgrade is A36.
JSON: {"count": 1}
sparql run 1
1. The only downgrade is A36; A35 is a Rating Watch Negative, not a downgrade.
JSON: {"count": 1}
sparql run 2
1. A36 is the only downgrade action on E14.
JSON: {"count": 1}
sparql run 3
1 (A23).
JSON: {"count": 1}
sparql run 4
1, from A36 only.
JSON: {"count": 1}
sparql run 5
1, the downgrade A36.
JSON: {"count": 1}
sparql+ontology run 1
1. The only DG on E14 is 2024-09-30.
JSON: {"count": 1}
sparql+ontology run 2
1. E14 has one Downgraded action, on 2024-09-30.
JSON: {"count": 1}
sparql+ontology run 3
1. Only A36 is a downgrade; A35 is a Watch and A33 an affirmation.
JSON: {"count": 1}
sparql+ontology run 4
1, which is A36.
JSON: {"count": 1}
sparql+ontology run 5
1. The only downgrade is 2024-09-30 (E14); the Rating Watch and the affirmation are not downgrades.
JSON: {"count": 1}
sql+executed run 1
1. E14 was downgraded once, on 2024-09-30 (A36).
JSON: {"count": 1}
sql+executed run 2
1. Only the 2024-09-30 downgrade from A- to BBB+ (A36) counts.
JSON: {"count": 1}
sql+executed run 3
1. Only A36 is a downgrade for E14.
JSON: {"count": 1}
sql+executed run 4
1. The only downgrade was A- to BBB+ on 2024-09-30 (A36).
JSON: {"count": 1}
sql+executed run 5
1. The only downgrade is A- to BBB+ on 2024-09-30. The watch placement is not a downgrade.
JSON: {"count": 1}
sparql+axioms run 1
1. Only A36 is a downgrade (2024-09-30).
JSON: {"count": 1}
sparql+axioms run 2
1. E14 had one downgrade action (A36).
JSON: {"count": 1}
sparql+axioms run 3
One time (A36).
JSON: {"count": 1}
sparql+axioms run 4
1 (A36).
JSON: {"count": 1}
sparql+axioms run 5
Once (A36). A35 is a watch action, not a downgrade.
JSON: {"count": 1}