ACR Rule ID = 317

Qualified Student

GradeLevel equals '09' AND 
Magnet doesn not equal 'IB' AND 
PrimExceptCode does not equal 'P' AND 
PrimExceptCode doesn not equal 'J' AND 
PrimExceptCode doesn not equal 'W' AND 
FCATMathScore greater than '0' AND 
FCATMathScore less than or equal to '0225';

SELECT DISTINCT magnet.student_id 
FROM student_attribute as magnet 
INNER JOIN (
  SELECT DISTINCT grade.student_id 
  FROM student_attribute as grade 
  INNER JOIN (
    (SELECT DISTINCT primCode.student_id 
    FROM student_attribute AS primCode 
    WHERE primCode.student_attribute_rule_id = 14 AND primCode.transferred_value != 'J' AND primCode.transferred_value != 'P' AND primCode.transferred_value != 'W'
    ) 
    UNION 
    (SELECT DISTINCT primNull.student_id 
    FROM student_attribute AS primNull 
    WHERE primNull.student_attribute_rule_id = 14 AND primNull.transferred_value IS NULL
    )
  ) AS prim ON prim.student_id = grade.student_id 
  WHERE grade.student_attribute_rule_id = 8 AND grade.transferred_value = '09'
) AS afterGrade ON afterGrade.student_id = magnet.student_id 
WHERE magnet.student_attribute_rule_id = 23 AND magnet.transferred_value != 'IB' OR magnet.transferred_value IS NULL;

SELECT DISTINCT student_id 
FROM student_test_score_summary 
WHERE student_test_score_summary_rule_id = 6 AND transferred_value > '0' AND transferred_value <= '0225';

SELECT DISTINCT score.student_id 
FROM student_test_score_summary AS score 
INNER JOIN (
  SELECT DISTINCT magnet.student_id 
  FROM student_attribute as magnet 
  INNER JOIN (
    SELECT DISTINCT grade.student_id 
    FROM student_attribute as grade 
    INNER JOIN (
      (SELECT DISTINCT primCode.student_id 
      FROM student_attribute AS primCode 
      WHERE primCode.student_attribute_rule_id = 14 AND primCode.transferred_value != 'J' AND primCode.transferred_value != 'P' AND primCode.transferred_value != 'W'
      ) 
      UNION 
      (SELECT DISTINCT primNull.student_id 
      FROM student_attribute AS primNull 
      WHERE primNull.student_attribute_rule_id = 14 AND primNull.transferred_value IS NULL
      )
    ) AS prim ON prim.student_id = grade.student_id 
    WHERE grade.student_attribute_rule_id = 8 AND grade.transferred_value = '09'
  ) AS afterGrade ON afterGrade.student_id = magnet.student_id 
WHERE magnet.student_attribute_rule_id = 23 AND magnet.transferred_value != 'IB' OR magnet.transferred_value IS NULL
) AS attribute ON score.student_id = attribute.student_id
WHERE score.student_test_score_summary_rule_id = 6 AND score.transferred_value > '0' AND score.transferred_value <= '0225';

Suppose that transferred_value in test_score_summary table is what we need