Referencia Cruzada

Create table notas(
idMatricula Char(3) primary key,
idCurso char(5),
nota numeric,
unidad
);
insert into notas values('001','MA100',10,1);
insert into notas values('001','MA100',14,2);
insert into notas values('001','MA100',11,3);
insert into notas values('002','MA100',08,4);
insert into notas values('002','MA100',15,3);
insert into notas values('002','MA100',6,4);
insert into notas values('002','MA100',10,4);
insert into notas values('003','MA100',19,4);
insert into notas values('003','MA100',20,5);
insert into notas values('001','FI100',11,1);
insert into notas values('001','FI100',15,2);
insert into notas values('001','FI100',16,3);
insert into notas values('002','FI100',09,4);
insert into notas values('002','FI100',14,3);
insert into notas values('002','FI100',9,4);
insert into notas values('002','FI100',08,4);
insert into notas values('003','FI100',16,4);
insert into notas values('003','FI100',13,5);
insert into notas values('001','QI100',10,1);
insert into notas values('001','QI100',11,2);
insert into notas values('001','QI100',12,3);
insert into notas values('002','QI100',14,4);
insert into notas values('002','QI100',08,3);
insert into notas values('002','QI100',12,4);
insert into notas values('002','QI100',18,4);
insert into notas values('003','QI100',17,4);
insert into notas values('003','QI100',04,5);

-- Cantidad de alumnos por Curso. Donde El nombre de curso sea la columna