I hope somebody can help me to produce the output as shown
ID NAME COURSE REC OF R2001
16DAT03F501 NUR ZAYANA BINTI MD YUSOF DAT 2
16DAT03F502 AZLIZA BINTI ZAINAL DAT 1
My problem is, i have no idea to get the output at the last
column. I want the total output (REC OF R2001) for each ID. Let
say, NUR ZAYANA have 2 records of R2001 and the list should show
the total of her record for R2001.