Gender Count by Degree Program This is a very basic query/report that you could use to compare the number of students in a specified degree program by year_of_study, by gender. This is also a good sample of how to use the count function. Load the query and modify it to suit your needs: perhaps qualify by status_code, or change it to count by concentration (subject_one or subject_two).