plan data compiler

[denniwang]

❓Problem: neu admin would like to see how many people in X major want to take course Y in semester Z in their starred plan.

💡 Solution : create endpoints to take inputs X?,Y?, and Z; return num of hits and user emails. X and Y can be optional parameters in the query

⏰ Est. Time : full week

📝 Notes : none

[denniwang]

please tinker around with the query implementation to find optimal approach / alternatives! @ShireenKumar

[ShireenKumar]

Some rough queries to create:

• How many students have a specific class in their starred plan (can be based on major/year/semester)
• How many students are taking a specific class based on their major within a specific year/semester
• Top 5 starred class that students are taking based on their major
• % of students taking a specific class based on major/year/semester

Data returned/required: Class code, major (potentially), semester, year, student's starred plans
Files to look at/edit: Student.entity, Plan.entity, Student.controller, Plan.controller