Unfulfilled classes

We need to run a report showing which class is needed per student.  For example, 10 students need Old Testament Lit, 3 are freshman, 2 sophomore, 5 junior. We run this report to show which class needs to be taught as a winter session class.  Thank you for your consideration on this need.