Given the following table, what's the SQL statement to find how many more units a student needs to take in each category?
(SSN is the student's ID #, MIN_UNITS is the minimum units required for the corresponding category.
The table COURSE shows all the courses the student has taken already)
COURSE
SSN COURSE# UNITS COURSE CATEGORY MIN_UNITS
134 11 4 art 30 elective 40
134 15 4 music 34 elective 24
134 25 2 art 55 general 24
134 17 4 art 35 elective 24
(SSN is the student's ID #, MIN_UNITS is the minimum units required for the corresponding category.
The table COURSE shows all the courses the student has taken already)
COURSE
SSN COURSE# UNITS COURSE CATEGORY MIN_UNITS
134 11 4 art 30 elective 40
134 15 4 music 34 elective 24
134 25 2 art 55 general 24
134 17 4 art 35 elective 24