   SELECT asn_id,
     (SELECT id FROM sparkpoints WHERE code = 'ELA.WRT.GRA') AS sparkpoint_id
   FROM get_descendant_standards_nodes('S11438C0')
-);
-
-INSERT into sparkpoint_standard_alignments (asn_id, sparkpoint_id) (
+
+  UNION
+
   SELECT asn_id,
     (SELECT id FROM sparkpoints WHERE code = 'ELA.WRT.XD') AS sparkpoint_id
   FROM get_descendant_standards_nodes('S11437A5')


  -- 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.WRT.PRO') AS sparkpoint_id
  FROM get_descendant_standards_nodes('S1143AE1')

  UNION

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

  UNION

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