Table: subjects_progress
Columns: subjects
first_year
second_year
third_year
fourth_year

Question: What is the third year course in science?
SQL: SELECT "third_year" FROM subjects_progress WHERE "subjects" = 'Science'

Question: What is the second year class following pag-unawa?
SQL: SELECT "second_year" FROM subjects_progress WHERE "first_year" = 'Pag-unawa'

Question: How many classes are taken in the third year when pag-unawa was taken in the first year?
SQL: SELECT COUNT("third_year") FROM subjects_progress WHERE "first_year" = 'Pag-unawa'

Question: What is the first year course in the program where geometry is taken in the third year?
SQL: SELECT "first_year" FROM subjects_progress WHERE "third_year" = 'Geometry'

Question: What is the second year course in the program where physics is taken in the fourth year?
SQL: SELECT "second_year" FROM subjects_progress WHERE "fourth_year" = 'Physics'