Q36, run 2026-11-04-2024-sonnet-query
How many entities are in the Northwind group, the parent included?
Tests: Groups and identity: two records of the parent are one entity.
Expected: count = 2
sql run 1
2: E02 and E04. E03 is a duplicate of E02.
JSON: {"count": 2}
sql run 2
2 (E02, E04).
JSON: {"count": 2}
sql run 3
2 (E02, E04).
JSON: {"count": 2}
sql+markdown run 1
2 (E02, E04).
JSON: {"count": 2}
sql+markdown run 2
2 (E02, E04). E03 is a second record of E02.
JSON: {"count": 2}
sql+markdown run 3
2 (E02, E04).
JSON: {"count": 2}
sparql run 1
2: E02 and E04. E03 duplicates E02.
JSON: {"count": 2}
sparql run 2
2: E02 and E04.
JSON: {"count": 2}
sparql run 3
2: E02 and E04.
JSON: {"count": 2}
sparql+ontology run 1
2: E02 and E04. E03 is the same entity as E02.
JSON: {"count": 2}
sparql+ontology run 2
2. E02 and E03 are one entity, and E04 is its subsidiary.
JSON: {"count": 2}
sparql+ontology run 3
2.
JSON: {"count": 2}
sql+executed run 1
2 entities: E02 and E04.
JSON: {"count": 2}
sql+executed run 2
2 (E02, E04).
JSON: {"count": 2}
sql+executed run 3
2.
JSON: {"count": 2}
sparql+axioms run 1
2 (E02/E03 count as one entity, plus E04).
JSON: {"count": 2}
sparql+axioms run 2
2 (E02/E03 and E04).
JSON: {"count": 2}
sparql+axioms run 3
2 (E02, which is also E03, and E04).
JSON: {"count": 2}