Q59, run 2026-11-04-2024-sonnet-query
How many entities in the Cerid Group plc group sit exactly three levels below the top?
Tests: Paths: depth in the tree, across the RESEARCH record.
Expected: count = 12
sql run 1
12.
JSON: {"count": 12}
sql run 2
11.
JSON: {"count": 11}
Why: count: expected 12, got 11
sql run 3
11.
JSON: {"count": 11}
Why: count: expected 12, got 11
sql+markdown run 1
8.
JSON: {"count": 8}
Why: count: expected 12, got 8
sql+markdown run 2
12.
JSON: {"count": 12}
sql+markdown run 3
12.
JSON: {"count": 12}
sparql run 1
(no answer found)
JSON: {"count": 0}
Why: count: expected 12, got 0
sparql run 2
12. This is 11 by the parent links, plus E5011 once E5167 and E5005 are merged.
JSON: {"count": 12}
sparql run 3
(no answer found)
JSON: {"count": 0}
Why: count: expected 12, got 0
sparql+ontology run 1
12.
JSON: {"count": 12}
sparql+ontology run 2
12.
JSON: {"count": 12}
sparql+ontology run 3
12.
JSON: {"count": 12}
sql+executed run 1
12 entities sit exactly three levels below E5001.
JSON: {"count": 12}
sql+executed run 2
12.
JSON: {"count": 12}
sql+executed run 3
12.
JSON: {"count": 12}
sparql+axioms run 1
12.
JSON: {"count": 12}
sparql+axioms run 2
About 12, from the E5001 hierarchy; E5011/E5012 also have a second parent, E5167, so this may be off.
JSON: {"count": 12}
sparql+axioms run 3
12 (E5011 to E5022).
JSON: {"count": 12}