1. select assignment_id, program from assignment_programs_rt where program in ('enVision Algebra 1 2018','enVision Algebra 1 Common Core 2018',
2. 'enVision Algebra 2 2018','enVision Algebra 2 Common Core 2018','enVision Custom Algebra 1','enVision Custom Algebra 2',
3. 'enVision Custom Geometry','enVision Florida Algebra 1 2020','enVision Florida Algebra 2 2020','enVision Florida Geometry 2020',
4. 'enVision Florida Mathematics 2020 Advanced Grade 6','enVision Florida Mathematics 2020 Advanced Grade 7',
5. 'enVision Florida Mathematics 2020 Grade 1','enVision Florida Mathematics 2020 Grade 2','enVision Florida Mathematics 2020 Grade 3',
6. 'enVision Florida Mathematics 2020 Grade 4','enVision Florida Mathematics 2020 Grade 5','enVision Florida Mathematics 2020 Grade 6',
7. 'enVision Florida Mathematics 2020 Grade 7','enVision Florida Mathematics 2020 Grade 8','enVision Florida Mathematics 2020 Grade K',
8. 'enVision Geometry 2018','enVision Geometry Common Core 2018','enVisionmath2.0 Common Core Grade 3 2016','enVisionmath2.0 Common Core Grade 4 2016',
9. 'enVisionmath2.0 Common Core Grade 5 2016','enVisionmath2.0 Common Core Grades 6-8 Accelerated Grade 7 2018',
10. 'enVisionmath2.0 Common Core Grades 6-8 Grade 6 2017','enVisionmath2.0 Common Core Grades 6-8 Grade 7 2017',
11. 'enVisionmath2.0 Common Core Grades 6-8 Grade 8 2017','enVisionmath2.0 Custom Grade 3','enVisionmath2.0 Custom Grade 4',
12. 'enVisionmath2.0 Custom Grade 5','enVisionmath2.0 Custom Grades 6-8 Grade 6','enVisionmath2.0 Custom Grades 6-8 Grade 7',
13. 'enVisionmath2.0 Custom Grades 6-8 Grade 8','enVisionmath2.0 Grade 3 2017','enVisionmath2.0 Grade 4 2017','enVisionmath2.0 Grade 5 2017',
14. 'enVisionmath2.0 Grades 6-8 Accelerated Grade 7 2018','enVisionmath2.0 Grades 6-8 Grade 6 2017','enVisionmath2.0 Grades 6-8 Grade 7 2017',
15. 'enVisionmath2.0 Grades 6-8 Grade 8 2017','enVisionmath2.0 Indiana Grade 3 2017','enVisionmath2.0 Indiana Grade 4 2017',
16. 'enVisionmath2.0 Indiana Grade 5 2017','enVisionmath2.0 Indiana Grades 6-8 Grade 6 2017','enVisionmath2.0 Indiana Grades 6-8 Grade 7 2017',
17. 'enVisionmath2.0 Indiana Grades 6-8 Grade 8 2017','enVisionmath2.0 Pennsylvania Grade 3 2016','enVisionmath2.0 Pennsylvania Grade 4 2016',
18. 'enVisionmath2.0 Pennsylvania Grade 5 2016','enVisionmath2.0 Pennsylvania Grades 6-8 Grade 6 2017',
19. 'enVisionmath2.0 Pennsylvania Grades 6-8 Grade 7 2017','enVisionmath2.0 Pennsylvania Grades 6-8 Grade 8 2017')
20. group by assignment_id, program;