Q44, run 2026-11-06-0808-sonnet-query

← back to the run

Which institutions are part of the Albury University System, at any level below it?

Tests: Local type: an affiliated institute (AFF) is not a unit of its parent.

Expected: institutions = ['I02', 'I03', 'I04', 'I05']

❌ D1 sql run 1 graded by code · query session

I02, I03, I04, I05, I06.

JSON: {"institutions": ["I02", "I03", "I04", "I05", "I06"]}

Why: institutions: expected ['I02', 'I03', 'I04', 'I05'], got ['I02', 'I03', 'I04', 'I05', 'I06']

❌ D1 sql run 2 graded by code · query session

I02, I03, I04, I05, I06.

JSON: {"institutions": ["I02", "I03", "I04", "I05", "I06"]}

Why: institutions: expected ['I02', 'I03', 'I04', 'I05'], got ['I02', 'I03', 'I04', 'I05', 'I06']

❌ D1 sql run 3 graded by code · query session

I02, I03, I04, I05, I06.

JSON: {"institutions": ["I02", "I03", "I04", "I05", "I06"]}

Why: institutions: expected ['I02', 'I03', 'I04', 'I05'], got ['I02', 'I03', 'I04', 'I05', 'I06']

❌ D1 sql run 4 graded by code · query session

I02, I03, I04, I05, I06.

JSON: {"institutions": ["I02", "I03", "I04", "I05", "I06"]}

Why: institutions: expected ['I02', 'I03', 'I04', 'I05'], got ['I02', 'I03', 'I04', 'I05', 'I06']

❌ D1 sql run 5 graded by code · query session

I02, I03, I04, I05, I06.

JSON: {"institutions": ["I02", "I03", "I04", "I05", "I06"]}

Why: institutions: expected ['I02', 'I03', 'I04', 'I05'], got ['I02', 'I03', 'I04', 'I05', 'I06']

✅ D2 sql+markdown run 1 graded by code · query session

I02, I03, I04, I05. I06 is an affiliated institute, so it is not part of the system.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D2 sql+markdown run 2 graded by code · query session

I02, I03, I04, I05. I06 is an affiliated institute and is excluded.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D2 sql+markdown run 3 graded by code · query session

I02, I03, I04, I05. I06 is an affiliated institute and is not part of the system.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D2 sql+markdown run 4 graded by code · query session

I02, I03, I04, I05. I06 is excluded as an affiliated institute.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D2 sql+markdown run 5 graded by code · query session

I02, I03, I04 and I05. I06 is excluded because it is an affiliated institute.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D3 sql+executed run 1 graded by code · query session

I02, I03, I04, I05. I06 is only an affiliate and does not roll up to I01.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D3 sql+executed run 2 graded by code · query session

I02, I03, I04, I05.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D3 sql+executed run 3 graded by code · query session

I02, I03, I04 and I05. I06 has I02 as its parent, but `institution_units` does not count it towards I02 or I01.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D3 sql+executed run 4 graded by code · query session

I02, I03, I04 and I05. I06 has I02 as its parent_id, but it is an affiliate (AFF) type and institution_units does not roll its works up, so I excluded it.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D3 sql+executed run 5 graded by code · query session

I02, I03, I04, I05. I06 counts only towards itself.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

❌ D4 sparql run 1 graded by code · query session

I02, I03, I04, I05 and I06.

JSON: {"institutions": ["I02", "I03", "I04", "I05", "I06"]}

Why: institutions: expected ['I02', 'I03', 'I04', 'I05'], got ['I02', 'I03', 'I04', 'I05', 'I06']

❌ D4 sparql run 2 graded by code · query session

(no answer found)

Why: no structured answer

❌ D4 sparql run 3 graded by code · query session

I02, I03, I04, I05, I06.

JSON: {"institutions": ["I02", "I03", "I04", "I05", "I06"]}

Why: institutions: expected ['I02', 'I03', 'I04', 'I05'], got ['I02', 'I03', 'I04', 'I05', 'I06']

❌ D4 sparql run 4 graded by code · query session

I02, I03, I04, I05, I06.

JSON: {"institutions": ["I02", "I03", "I04", "I05", "I06"]}

Why: institutions: expected ['I02', 'I03', 'I04', 'I05'], got ['I02', 'I03', 'I04', 'I05', 'I06']

❌ D4 sparql run 5 graded by code · query session

I02, I03, I04, I05, I06.

JSON: {"institutions": ["I02", "I03", "I04", "I05", "I06"]}

Why: institutions: expected ['I02', 'I03', 'I04', 'I05'], got ['I02', 'I03', 'I04', 'I05', 'I06']

✅ D5 sparql+ontology run 1 graded by code · query session

I02, I03, I04, I05. I06 is an affiliated institute and is not a unit.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D5 sparql+ontology run 2 graded by code · query session

I02, I03, I04, I05. I06 is excluded because it is an affiliated institute.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D5 sparql+ontology run 3 graded by code · query session

I02, I03, I04 and I05. I06 is excluded because it is an affiliated institute (AFF).

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D5 sparql+ontology run 4 graded by code · query session

I02, I03, I04 and I05. I06 is excluded because it is an affiliated institute.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}

✅ D5 sparql+ontology run 5 graded by code · query session

I02, I03, I04, I05. I06 is an affiliated institute, so it is excluded.

JSON: {"institutions": ["I02", "I03", "I04", "I05"]}