Q13, run 2026-11-06-0041-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. The only downgrade is A36.
JSON: {"count": 1}
sql run 2
1. The only downgrade is A36.
JSON: {"count": 1}
sql run 3
1. The only downgrade is A36.
JSON: {"count": 1}
sql run 4
1, from A36.
JSON: {"count": 1}
sql run 5
1. Only A36 is a downgrade; A35 is a watch and A33 an affirmation.
JSON: {"count": 1}
sql+markdown run 1
1. A36 is the only DG for E14.
JSON: {"count": 1}
sql+markdown run 2
1, from A36.
JSON: {"count": 1}
sql+markdown run 3
1. The only downgrade of E14 is A36.
JSON: {"count": 1}
sql+markdown run 4
1. The only downgrade is A36.
JSON: {"count": 1}
sql+markdown run 5
1, from A36.
JSON: {"count": 1}
sparql run 1
1, from A36.
JSON: {"count": 1}
sparql run 2
1, from A36.
JSON: {"count": 1}
sparql run 3
1. Only A36 is a downgrade. The rating watch (A35) and the affirmation (A33) are not downgrades.
JSON: {"count": 1}
sparql run 4
1. Only A36 is a downgrade for E14.
JSON: {"count": 1}
sparql run 5
1. The only downgrade is A36.
JSON: {"count": 1}
sparql+ontology run 1
1. Only A36 is a DG; the Watch (A35) is not a downgrade.
JSON: {"count": 1}
sparql+ontology run 2
1. Only A36 is a downgrade, and the Rating Watch (A35) is not.
JSON: {"count": 1}
sparql+ontology run 3
1. Only A36 is a downgrade; A35 is a Watch and A33 is an affirmation.
JSON: {"count": 1}
sparql+ontology run 4
1. Only A36 is a DG for E14. A35 is a Watch and A33 an affirmation.
JSON: {"count": 1}
sparql+ontology run 5
1, which is A36.
JSON: {"count": 1}
sql+executed run 1
1. The only DG action for E14 is A36; the others are a watch action and an affirmation.
JSON: {"count": 1}
sql+executed run 2
1. The only downgrade was A- to BBB+ on 2024-09-30 (A36); the later watch and affirmation did not change the rating.
JSON: {"count": 1}
sql+executed run 3
1. The only downgrade was A- to BBB+ on 2024-09-30. The RWN period and the later affirmation are not downgrades.
JSON: {"count": 1}
sql+executed run 4
Once, A- to BBB+ on 2024-09-30 (A36). The Rating Watch Negative action (A35) is not a downgrade.
JSON: {"count": 1}
sql+executed run 5
1. The only downgrade is A36 on 2024-09-30; A35 is a watch action at the same rating.
JSON: {"count": 1}
sparql+axioms run 1
1. Only A36 is a downgrade; the later E14 actions are a watch and an affirmation.
JSON: {"count": 1}
sparql+axioms run 2
1. Only A36 is a downgrade for E14.
JSON: {"count": 1}
sparql+axioms run 3
1, the downgrade A36.
JSON: {"count": 1}
sparql+axioms run 4
1. The only downgrade is A36, from A- to BBB+.
JSON: {"count": 1}
sparql+axioms run 5
1. A36 is the only downgrade action; A35 was a watch and A33 an affirmation.
JSON: {"count": 1}