Q61, run 2026-11-04-2024-sonnet-query
How many members of the Cerid Group plc group, the top included, hold a foreign-currency issuer rating below investment grade?
Tests: Paths and test data: the QA record under the top has a B- rating, and is ignored.
Expected: count = 19
sql run 1
20.
JSON: {"count": 20}
Why: count: expected 19, got 20
sql run 2
18.
JSON: {"count": 18}
Why: count: expected 19, got 18
sql run 3
18 members hold a sub-investment-grade foreign-currency issuer rating.
JSON: {"count": 18}
Why: count: expected 19, got 18
sql+markdown run 1
2 (E5016 BB- and E5031 B).
JSON: {"count": 2}
Why: count: expected 19, got 2
sql+markdown run 2
19.
JSON: {"count": 19}
sql+markdown run 3
19.
JSON: {"count": 19}
sparql run 1
(no answer found)
JSON: {"count": 0}
Why: count: expected 19, got 0
sparql run 2
20. This counts 18 members rated below investment grade by the parent links, plus E5023 and E5047 via the duplicate.
JSON: {"count": 20}
Why: count: expected 19, got 20
sparql run 3
Not determined.
JSON: {"count": 0}
Why: count: expected 19, got 0
sparql+ontology run 1
19.
JSON: {"count": 19}
sparql+ontology run 2
20.
JSON: {"count": 20}
Why: count: expected 19, got 20
sparql+ontology run 3
19.
JSON: {"count": 19}
sql+executed run 1
19 members hold a foreign-currency issuer rating below investment grade, and the top entity E5001 is not among them.
JSON: {"count": 19}
sql+executed run 2
19.
JSON: {"count": 19}
sql+executed run 3
19.
Correction to the Q30 entry in the JSON block: it contains a stray "E1019x" by mistake. E1019 is BB+ against an A ceiling, so it is not at its ceiling. I also left out E1307, which is BB- against BB. The correct Q30 list has 13 entities: E05, E1028, E1039, E1101, E1126, E1194, E1236, E15, E5012, E5047, E5091, E5116, E5124. That corrects the count of 14 stated in the Q30 answer above.
JSON: {"count": 19}
sparql+axioms run 1
19.
JSON: {"count": 19}
sparql+axioms run 2
At least 3 (E5012 at BB, E5023 and E5024 at B-, all VD-domiciled); I did not check the rest of the group.
JSON: {"count": 3}
Why: count: expected 19, got 3
sparql+axioms run 3
19.
JSON: {"count": 19}