ICT AS level paper 2 help..HELP (database)

[Patum]

hey guys, i'm trying to work out something but I don't know how to..
here's an example;
If there is a list of names of students ( don't know how many) taking part in a variety of exam courses (each students does only one course), how do i calculate the number of students taking part in each exam course? - this is a database questions, i need to make a query and add a new field to calculate the number of students doing each exam course.. Help?

 

[klaz]

sefiooooooooooooooooooooooooooooooooooon hhhaahhahahahhahaahhahahahaa

 

[sweetiepie]

https://www.xtremepapers.com/community/threads/computers-ict-post-your-doubts-here.10038/ ask here