SELECT
  disabil_type,
  dec1_cnt
FROM dec_child_count
WHERE sch_year = ?
  AND grade_num = ?
  AND disabil_type != 'ALL'
  -- state level
  AND div_num = 0
  AND sch_num = 0
  -- all students
  AND race = 'ALL'
  AND gender = 'ALL'
  AND disabil = 'Y'
  AND lep = 'ALL'
  AND disadva = 'ALL'
