Hello Noel,

do you really need the output exactly as you wrote or would you like to get the result of how many female/male persons visited that course per year?

I would suggest something like this:

Select Course_Code as course, stud_year as year, count(Gender) as counted_gender, gender_text = CASE gender when 1 THEN 'male' ELSE 'female' END
FROM table_A 
GROUP by Course_Code, stud_year, gender 
order by course, year, gender

I hope, I could help you a bit
greetings Judith