 ELA.WRT.RES => S1143938
 ELA.WRT.GRA => S1143730, S11436AA
 
-ELA.VOC => S11437EB, S1143730
+ELA.VOC => S11437EB
  */
 
 TRUNCATE TABLE sparkpoint_standard_alignments;


  -- INSERT INTO "sparkpoints" (student_title, abbreviation, subject, content_area_id, automatic) VALUES (
  --  'Grammar', 'GRA', 'English', content_area_id, true
  -- ) RETURNING id INTO grammar_id;

  INSERT INTO "sparkpoints" (student_title, abbreviation, parent_id, subject, content_area_id, automatic) VALUES


  SELECT asn_id,
    (SELECT id FROM sparkpoints WHERE code = 'ELA.RDG.XD') AS sparkpoint_id
  FROM get_descendant_standards_nodes('S11437A4')

  UNION

  SELECT asn_id,
    (SELECT id FROM sparkpoints WHERE code = 'ELA.WRT.GRA') AS sparkpoint_id
  FROM get_descendant_standards_nodes('S1143936')
