Q25, run 2026-11-05-1515-sonnet-query
How many instruments held an investment-grade rating on 1 October 2026?
Tests: Instrument ratings: counted on the instrument's own rating, not its issuer's.
Expected: count = 72
sql run 1
72. I count the latest rating per instrument, excluding expired ones such as I08.
JSON: {"count": 72}
sql run 2
72. This counts each instrument's latest rating at BBB- or better and excludes the matured (EX) ones.
JSON: {"count": 72}
sql run 3
72. This is the number of instruments whose latest rating on 1 Oct 2026 was investment grade and not an expiry (EX).
JSON: {"count": 72}
sql run 4
72 of the 113 rated instruments are investment grade as of 2026-10-01.
JSON: {"count": 72}
sql run 5
72. This counts instruments whose latest INST rating is BBB- or better and has not expired (EX).
JSON: {"count": 72}
sql+markdown run 1
72 instruments held an investment-grade rating on 1 Oct 2026. EX actions are excluded.
JSON: {"count": 72}
sql+markdown run 2
72 instruments held an investment-grade rating on 2026-10-01, excluding EX-only ratings.
JSON: {"count": 72}
sql+markdown run 3
72. Of the 113 instruments with a rating in force on 1 Oct 2026, 72 were BBB- or higher; Expected ratings (EX) are not ratings.
JSON: {"count": 72}
sql+markdown run 4
72. Of 113 instruments with a rating on 2026-10-01, 72 are investment grade; expected ratings (EX) are not counted.
JSON: {"count": 72}
sql+markdown run 5
72. This is the number of instruments whose latest non-EX rating on 1 Oct 2026 was BBB- or better.
JSON: {"count": 72}
sparql run 1
Not determined. My queries for instrument counts returned nothing usable.
JSON: {"count": null}
Why: count: expected 72, got None
sparql run 2
75, out of 119 rated instruments.
JSON: {"count": 75}
Why: count: expected 72, got 75
sparql run 3
(no answer found)
JSON: {"count": null}
Why: count: expected 72, got None
sparql run 4
I could not determine this. My query had a bug and returned 0.
JSON: {"count": null}
Why: count: expected 72, got None
sparql run 5
72. Of 113 instruments rated on 1 October 2026, 72 were investment grade.
JSON: {"count": 72}
sparql+ontology run 1
(no answer found)
JSON: {"count": null}
Why: count: expected 72, got None
sparql+ontology run 2
72. This counts instruments whose latest non-Expected action by 1 Oct 2026 left them at BBB- or higher.
JSON: {"count": 72}
sparql+ontology run 3
72 of the 113 instruments with a rating in force on 2026-10-01 were BBB- or higher. Expected ratings are not counted.
JSON: {"count": 72}
sparql+ontology run 4
72. Of 113 rated instruments on 1 October 2026, 72 were investment grade, with Expected-rating (EX) actions excluded.
JSON: {"count": 72}
sparql+ontology run 5
72 instruments held an investment-grade rating on 1 October 2026. Expected ratings (EX) were excluded.
JSON: {"count": 72}
sql+executed run 1
72 instruments held an investment-grade rating.
JSON: {"count": 72}
sql+executed run 2
72 instruments were rated BBB- or higher on 1 October 2026.
JSON: {"count": 72}
sql+executed run 3
72 instruments held an investment-grade rating.
JSON: {"count": 72}
sql+executed run 4
72 instruments held an investment-grade (BBB- or above) rating.
JSON: {"count": 72}
sql+executed run 5
72 instruments.
JSON: {"count": 72}
sparql+axioms run 1
72 of the 113 rated instruments.
JSON: {"count": 72}
sparql+axioms run 2
72. Of the 113 instruments rated on 1 October 2026, 72 are BBB- or better.
JSON: {"count": 72}
sparql+axioms run 3
72 instruments held an investment-grade rating in force on 1 October 2026.
JSON: {"count": 72}
sparql+axioms run 4
72, summing the investment-grade rating buckets of instruments in force.
JSON: {"count": 72}
sparql+axioms run 5
72 instruments held an investment-grade rating.
JSON: {"count": 72}