Table: student_progress
Columns: subject
freshman_grade_7
sophomore_grade_8
junior_3rd_year
senior_4th_year

Question: How many classes between senior and junior year for world history
SQL: SELECT COUNT("senior_4th_year") FROM student_progress WHERE "junior_3rd_year" = 'World History'

Question: What is after intermediate algebra
SQL: SELECT "senior_4th_year" FROM student_progress WHERE "sophomore_grade_8" = 'Intermediate Algebra'