Q32, run 2026-11-04-1738-sonnet-query
Who is Halden Leasing's ultimate parent?
Tests: Groups: the chain of parents, two levels up.
Expected: parent = E09
sql run 1
E09. E11's parent is E10, whose parent is E09.
JSON: {"parent": "E09"}
sql run 2
E09. E11's parent is E10, whose parent is E09.
JSON: {"parent": "E09"}
sql run 3
Halden Group plc (E09). The chain is E11 to E10 to E09.
JSON: {"parent": "E09"}
sql run 4
E09 (Halden Group). E11's parent is E10, whose parent is E09.
JSON: {"parent": "E09"}
sql run 5
E09. E11's parent is E10, and E10's parent is E09.
JSON: {"parent": "E09"}
sql+markdown run 1
E09. E11's parent is E10, whose parent is E09.
JSON: {"parent": "E09"}
sql+markdown run 2
E09, Halden Group plc. E11's parent is E10 (RATINGS record), and E10's parent is E09.
JSON: {"parent": "E09"}
sql+markdown run 3
E09. E11's parent is E10, whose parent is E09.
JSON: {"parent": "E09"}
sql+markdown run 4
E09. E11's parent is E10, whose parent is E09.
JSON: {"parent": "E09"}
sql+markdown run 5
Halden Group plc (E09), via E11 to E10 to E09.
JSON: {"parent": "E09"}
sparql run 1
Halden Group (E09). E11 has parent E10, and E10 has parent E09.
JSON: {"parent": "E09"}
sparql run 2
Halden Group plc (E09), via E11 → E10 → E09.
JSON: {"parent": "E09"}
sparql run 3
E09, via E11 → E10 → E09.
JSON: {"parent": "E09"}
sparql run 4
E09. E11's parent is E10, whose parent is E09.
JSON: {"parent": "E09"}
sparql run 5
E09. E11's parent is E10, and E10's parent is E09.
JSON: {"parent": "E09"}
sparql+ontology run 1
E09, via E11 → E10 → E09.
JSON: {"parent": "E09"}
sparql+ontology run 2
E09. The chain is E11 → E10 → E09 (Halden Group plc).
JSON: {"parent": "E09"}
sparql+ontology run 3
E09 (Halden Group). The chain is E11 to E10 to E09.
JSON: {"parent": "E09"}
sparql+ontology run 4
Halden Group plc (E09). E11 is owned by E10, which is owned by E09.
JSON: {"parent": "E09"}
sparql+ontology run 5
E09, via E11 to E10 to E09.
JSON: {"parent": "E09"}