Q48, run 2026-11-05-1515-sonnet-query
How many instruments held a rating on 1 October 2026?
Tests: Local action: the expected rating doesn't count.
Expected: count = 113
sql run 1
113. This counts instruments with a current rating, excluding expired ones.
JSON: {"count": 113}
sql run 2
113 instruments held a non-expired rating on 2026-10-01.
JSON: {"count": 113}
sql run 3
113. This is the number of instruments with a live rating on 1 Oct 2026.
JSON: {"count": 113}
sql run 4
113, counting instruments whose latest INST action is not EX or WD.
JSON: {"count": 113}
sql run 5
113. This counts instruments whose latest INST action is not an expiry.
JSON: {"count": 113}
sql+markdown run 1
113 instruments held a rating.
JSON: {"count": 113}
sql+markdown run 2
113 instruments held a rating on 2026-10-01.
JSON: {"count": 113}
sql+markdown run 3
113.
JSON: {"count": 113}
sql+markdown run 4
113. This counts instruments with a non-withdrawn rating on 2026-10-01 and excludes 9 with EX only.
JSON: {"count": 113}
sql+markdown run 5
113.
JSON: {"count": 113}
sparql run 1
Not determined, for the same reason as Q25.
JSON: {"count": null}
Why: count: expected 113, got None
sparql run 2
119.
JSON: {"count": 119}
Why: count: expected 113, got 119
sparql run 3
(no answer found)
JSON: {"count": null}
Why: count: expected 113, got None
sparql run 4
113.
JSON: {"count": 113}
sparql run 5
113.
JSON: {"count": 113}
sparql+ontology run 1
(no answer found)
JSON: {"count": null}
Why: count: expected 113, got None
sparql+ontology run 2
113. This counts rated instruments on 1 Oct 2026, excluding Expected, withdrawn and QA.
JSON: {"count": 113}
sparql+ontology run 3
113.
JSON: {"count": 113}
sparql+ontology run 4
113.
JSON: {"count": 113}
sparql+ontology run 5
113 instruments.
JSON: {"count": 113}
sql+executed run 1
113.
JSON: {"count": 113}
sql+executed run 2
113 instruments held a rating on 1 October 2026.
JSON: {"count": 113}
sql+executed run 3
113 instruments held a rating.
JSON: {"count": 113}
sql+executed run 4
113.
JSON: {"count": 113}
sql+executed run 5
113.
JSON: {"count": 113}
sparql+axioms run 1
113.
JSON: {"count": 113}
sparql+axioms run 2
113.
JSON: {"count": 113}
sparql+axioms run 3
113 instruments held a rating in force on 1 October 2026.
JSON: {"count": 113}
sparql+axioms run 4
113, summing the instruments in force by rating.
**Q49–Q59, Q61.** Not answered. My queries did not retrieve the group structure for these.
JSON: {"count": 113}
sparql+axioms run 5
113 instruments held an in-force rating.
JSON: {"count": 113}