import json

with open(r'c:\projects\myproject\azure-quiz\data\az-305\questions.json', 'r', encoding='utf-8') as f:
    data = json.load(f)

missing_stem = []
missing_expl = []
for q in data:
    qid = q['id']
    if qid < 100 or qid > 170:
        continue
    stem_vi = q['stem'].get('vi', '')
    expl_vi = q['explanation'].get('vi', '')
    if not stem_vi or stem_vi.strip() == '':
        missing_stem.append(qid)
    if not expl_vi or expl_vi.strip() == '':
        missing_expl.append(qid)

total = sum(1 for q in data if 100 <= q['id'] <= 170)
print(f'Total questions 100-170: {total}')
print(f'Missing Vietnamese stem: {len(missing_stem)} - IDs: {missing_stem}')
print(f'Missing Vietnamese explanation: {len(missing_expl)} - IDs: {missing_expl}')