Q30, run 2026-11-06-0935-sonnet-query
Which entities had a foreign-currency issuer rating exactly at their country's ceiling on 1 October 2026?
Tests: Ceilings: which ratings the cap binds.
Expected: entities = ['E05', 'E15']
sql run 1
E05 (FC BB, ceiling BB) and E15 (FC A, ceiling A).
JSON: {"entities": ["E05", "E15"]}
sql run 2
E05 (FC BB, matching Valdoria's ceiling of BB) and E15 (FC A, matching Corvenia's ceiling of A).
JSON: {"entities": ["E05", "E15"]}
sql run 3
E05 and E15. E05's foreign-currency rating is BB against the BB ceiling. E15's is A against the A ceiling.
JSON: {"entities": ["E05", "E15"]}
sql run 4
E15 and E05. E15's foreign-currency rating of A equals Corvenia's ceiling of A (A41, A37). E05's BB equals Valdoria's ceiling of BB (A14, A12).
JSON: {"entities": ["E05", "E15"]}
sql run 5
E05 and E15. E05's foreign-currency rating of BB equals the Valdoria ceiling of BB, and E15's A equals the Corvenia ceiling of A.
JSON: {"entities": ["E05", "E15"]}
sql+markdown run 1
E05 and E15. E05's FC rating is BB, equal to the VD ceiling of BB, and E15's FC rating is A, equal to the CV ceiling of A.
JSON: {"entities": ["E05", "E15"]}
sql+markdown run 2
E05 and E15. E05's FC rating is BB, equal to VD's ceiling of BB. E15's FC rating is A, equal to CV's ceiling of A.
JSON: {"entities": ["E05", "E15"]}
sql+markdown run 3
E05 (BB against a BB ceiling) and E15 (A against an A ceiling).
JSON: {"entities": ["E05", "E15"]}
sql+markdown run 4
E05 (FC BB, ceiling BB) and E15 (FC A, CV ceiling A).
JSON: {"entities": ["E05", "E15"]}
sql+markdown run 5
E05 and E15. E05's FC rating is BB, equal to VD's ceiling of BB, and E15's FC rating is A, equal to CV's ceiling of A.
JSON: {"entities": ["E05", "E15"]}
sparql run 1
E05 (BB against the ceiling of BB) and E15 (A against the ceiling of A).
JSON: {"entities": ["E05", "E15"]}
sparql run 2
E15 and E05. E15's foreign-currency rating of A equals Corvenia's ceiling of A (A37). E05's BB equals Valdoria's ceiling of BB (A12).
JSON: {"entities": ["E15", "E05"]}
sparql run 3
E05 (FC BB = VD ceiling BB) and E15 (FC A = CV ceiling A).
JSON: {"entities": ["E05", "E15"]}
sparql run 4
E05 (FC BB = VD ceiling BB) and E15 (FC A = CV ceiling A).
JSON: {"entities": ["E05", "E15"]}
sparql run 5
E05 and E15. E05's FC rating is BB, equal to VD's ceiling of BB. E15's FC rating is A, equal to CV's ceiling of A (A37).
JSON: {"entities": ["E05", "E15"]}
sparql+ontology run 1
E05 and E15. E05's FC rating is BB, equal to the VD ceiling (BB). E15's FC rating is A, equal to the CV ceiling (A).
JSON: {"entities": ["E05", "E15"]}
sparql+ontology run 2
E05 and E15. E05 is FC BB against a VD ceiling of BB, and E15 is FC A against a CV ceiling of A.
JSON: {"entities": ["E05", "E15"]}
sparql+ontology run 3
E05 and E15. E05's FC rating is BB, equal to VD's ceiling of BB. E15's FC rating is A, equal to CV's ceiling of A.
JSON: {"entities": ["E05", "E15"]}
sparql+ontology run 4
E05 and E15. E05's FC rating is BB, equal to VD's ceiling of BB, and E15's is A, equal to CV's ceiling of A.
JSON: {"entities": ["E05", "E15"]}
sparql+ontology run 5
E05 (FC BB, VD ceiling BB) and E15 (FC A, CV ceiling A).
JSON: {"entities": ["E05", "E15"]}
sql+executed run 1
E05 and E15. E05's foreign-currency rating is BB, equal to the VD ceiling BB, and E15's is A, equal to the CV ceiling A.
JSON: {"entities": ["E05", "E15"]}
sql+executed run 2
E05 and E15. E05's FC rating of BB equals the VD ceiling of BB, and E15's FC rating of A equals the CV ceiling of A.
JSON: {"entities": ["E05", "E15"]}
sql+executed run 3
E05 and E15. E05 is BB against a VD ceiling of BB, and E15 is A against a CV ceiling of A.
JSON: {"entities": ["E05", "E15"]}
sql+executed run 4
E05 and E15. E05's foreign-currency rating of BB equals VD's ceiling of BB, and E15's A equals CV's ceiling of A.
JSON: {"entities": ["E05", "E15"]}
sql+executed run 5
E05 and E15. E05 is BB against VD's BB ceiling, and E15 is A against CV's A ceiling.
JSON: {"entities": ["E05", "E15"]}
sparql+axioms run 1
E05 and E15. E05 is BB against Valdoria's BB ceiling, and E15 is A against Corvenia's A ceiling.
JSON: {"entities": ["E05", "E15"]}
sparql+axioms run 2
E05 and E15. Their foreign-currency ratings equal the ceilings of BB (VD) and A (CV).
JSON: {"entities": ["E05", "E15"]}
sparql+axioms run 3
E05 and E15. Their foreign-currency ratings equal their country ceilings: BB for Valdoria and A for Corvenia.
JSON: {"entities": ["E05", "E15"]}
sparql+axioms run 4
E05 (FC BB, ceiling BB) and E15 (FC A, ceiling A).
JSON: {"entities": ["E05", "E15"]}
sparql+axioms run 5
E05 (BB against a BB ceiling) and E15 (A against an A ceiling).
JSON: {"entities": ["E05", "E15"]}