Q40, run 2026-11-06-0935-sonnet-query
How many distinct issuers domiciled in GB held an issuer rating on 1 October 2026?
Tests: Identity and withdrawal: Northwind counted once, Pellam not at all, the QA record ignored.
Expected: count = 5
sql run 1
6, namely E01, E02, E09, E12, E14 and E16. E07 is excluded because its rating was withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
sql run 2
6 (E01, E02, E09, E12, E14, E16). E07 is excluded because its rating was withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
sql run 3
6: E01, E02/E03 (one entity), E09, E12, E14 and E16.
JSON: {"count": 6}
Why: count: expected 5, got 6
sql run 4
6: E01, E02, E09, E12, E14 and E16. E07's rating is withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
sql run 5
6: E01, E02, E09, E12, E14 and E16.
JSON: {"count": 6}
Why: count: expected 5, got 6
sql+markdown run 1
5. These are E01, E02/E03, E09, E12 and E14.
JSON: {"count": 5}
sql+markdown run 2
5. These are E01, E02, E09, E12 and E14. E07 is withdrawn and E16 is QA.
JSON: {"count": 5}
sql+markdown run 3
5: E01, E02, E09, E12 and E14. E07 was withdrawn, E16 is QA, and E10's country is LU per the RESEARCH record.
JSON: {"count": 5}
sql+markdown run 4
5. These are E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.
JSON: {"count": 5}
sql+markdown run 5
5. These are E01, E02, E09, E12 and E14. E07 is withdrawn, E16 is QA, and E10 is domiciled in LU per the RESEARCH record.
JSON: {"count": 5}
sparql run 1
6: E01, E02, E09, E12, E14 and E16. E07 is excluded because its rating was withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
sparql run 2
6: E01, E02 (with E03), E09, E12, E14 and E16.
JSON: {"count": 6}
Why: count: expected 5, got 6
sparql run 3
6: E01, E02, E09, E12, E14 and E16.
JSON: {"count": 6}
Why: count: expected 5, got 6
sparql run 4
6: E01, E02, E09, E12, E14 and E16.
JSON: {"count": 6}
Why: count: expected 5, got 6
sparql run 5
6. These are E01, E02, E09, E12, E14 and E16. E07 is excluded because its rating was withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
sparql+ontology run 1
5: E01, E02, E09, E12 and E14.
JSON: {"count": 5}
sparql+ontology run 2
5. These are E01, E02, E09, E12 and E14.
JSON: {"count": 5}
sparql+ontology run 3
5. These are E01, E02, E09, E12 and E14. E07 is withdrawn and E16 is QA.
JSON: {"count": 5}
sparql+ontology run 4
5: E01, E02, E09, E12 and E14. E07 is withdrawn and E16 is QA.
JSON: {"count": 5}
sparql+ontology run 5
5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.
JSON: {"count": 5}
sql+executed run 1
5: E01, E02, E09, E12 and E14. E07 is excluded because its rating was withdrawn.
JSON: {"count": 5}
sql+executed run 2
5: E01, E02, E09, E12 and E14.
JSON: {"count": 5}
sql+executed run 3
5. The GB issuers with an issuer rating on 2026-10-01 are E01, E02, E09, E12 and E14. E07 is withdrawn.
JSON: {"count": 5}
sql+executed run 4
5: E01, E02, E09, E12 and E14. E07 is excluded because its rating was withdrawn.
JSON: {"count": 5}
sql+executed run 5
5. The GB issuers with a current issuer rating are E01, E02, E09, E12 and E14. E07 is excluded because its rating was withdrawn.
JSON: {"count": 5}
sparql+axioms run 1
6. These are E01, E02, E09, E12, E14 and E16, counting E02 and E03 as one entity.
JSON: {"count": 6}
Why: count: expected 5, got 6
sparql+axioms run 2
6: E01, E02, E09, E12, E14 and E16. As with Q9, this includes E16; without it the count is 5.
JSON: {"count": 6}
Why: count: expected 5, got 6
sparql+axioms run 3
6. These are E01, E02/E03, E09, E12, E14 and E16 (5 if E16's A44 is excluded).
JSON: {"count": 6}
Why: count: expected 5, got 6
sparql+axioms run 4
5: E01, E02/E03, E09, E12 and E14. E16 is not counted because its A44 is not in force.
JSON: {"count": 5}
sparql+axioms run 5
6. They are E01, E02, E09, E12, E14 and E16.
JSON: {"count": 6}
Why: count: expected 5, got 6