Filtering students by GPA and time enrolled
Suppose you're given the tables below, containing information about various college programs, as well as students currently enrolled in the listed universities. Note that 'college_name_program_id' is a unique identifier for the college/program combination.
Using the tables above, write a SQL query to return the number of students in each department/program (agnostic of university) that have a GPA of at least 2.8 and have been enrolled for at least 2 years.
You can view/query this table in an interactive SQL fiddle here.
Subscribe to premium account to see the solution.Get premium now