Q44, run 2026-11-06-0519-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', 'I19', 'I20']

❌ D1 sql run 1 graded by code · query session

I02, I03, I04, I05, I06, I19, I20 and I21.

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

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

✅ D1 sql run 2 graded by code · query session

I02, I03, I04, I05, I19 and I20. I excluded the affiliates I06 and I21.

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

❌ D1 sql run 3 graded by code · query session

I02, I03, I04, I05, I06, I19, I20, I21.

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

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

❌ D1 sql run 4 graded by code · query session

I02, I03, I04, I05, I06, I19, I20 and I21.

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

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

❌ D1 sql run 5 graded by code · query session

I02, I03, I04, I05, I06, I19, I20, I21.

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

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

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

I02, I03, I04, I19, I05 and I20. The affiliated institutes I06 and I21 are not units of their parents.

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

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

I02, I03, I04, I05, I19, I20. The affiliated institutes I06 and I21 are excluded.

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

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

I02, I03, I04, I19, I05, I20. The affiliated institutes I06 and I21 are excluded.

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

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

I02, I03, I04, I19, I05 and I20. The affiliated institutes I06 and I21 are excluded.

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

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

I02, I03, I04, I19, I05 and I20. The affiliated institutes I06 and I21 are excluded.

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

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

I02, I03, I04, I05, I19 and I20. I06 is only affiliated and does not roll up in institution_units.

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

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

I02, I03, I04, I05, I19 and I20. I06 is only affiliated and does not roll up.

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

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

I02, I03, I04, I05, I19, I20. I06 and I21 are affiliates and do not count towards the system.

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

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

I02, I03, I04, I19, I05 and I20. I06 is only an affiliate: institution_units has it counting towards itself alone.

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

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

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

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

❌ D4 sparql run 1 graded by code · query session

I02, I03, I04, I05, I06, I19, I20 and I21.

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

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

❌ D4 sparql run 2 graded by code · query session

I02, I03, I04, I05, I06, I19, I20 and I21.

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

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

❌ D4 sparql run 3 graded by code · query session

I02, I03, I04, I05, I06, I19, I20, I21.

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

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

❌ D4 sparql run 4 graded by code · query session

I02, I03, I04, I05, I06, I19, I20 and I21.

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

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

❌ D4 sparql run 5 graded by code · query session

I02, I03, I04, I05, I06, I19, I20 and I21.

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

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

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

I02, I03, I04, I05, I19 and I20. I06 and I21 are affiliated institutes, so they are not units.

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

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

I02, I03, I04, I05, I19, I20. The affiliated institutes I06 and I21 are excluded.

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

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

I02, I03, I04, I05, I19, I20. The affiliated institutes I06 and I21 are not units.

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

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

I02, I03, I04, I05, I19 and I20. I06 and I21 are affiliated institutes, so they are not parts of the system.

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

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

I02, I03, I04, I05, I19 and I20. The affiliated institutes I06 and I21 are excluded.

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