Fabio,

Thank you for the superb reply. It was a very brilliant solution.

I've solve it in my own, but when I saw your solution, I adopted it.

It is easier to read and it has a lesser command.

Here is my solution using long method.

SELECT     COURSE_CODE,
                          (SELECT     COUNT(GENDER)
                            FROM          dbo.VW_SUMMARY TMP
                            WHERE      gender = 1 AND stud_year = 1 AND A.COURSE_CODE = TMP.COURSE_CODE) AS m1,
                          (SELECT     COUNT(GENDER)
                            FROM          dbo.VW_SUMMARY TMP
                            WHERE      gender = 2 AND stud_year = 1 AND A.COURSE_CODE = TMP.COURSE_CODE) AS f1,
                          (SELECT     COUNT(GENDER)
                            FROM          dbo.VW_SUMMARY TMP
                            WHERE      gender = 1 AND stud_year = 2 AND A.COURSE_CODE = TMP.COURSE_CODE) AS m2,
                          (SELECT     COUNT(GENDER)
                            FROM          dbo.VW_SUMMARY TMP
                            WHERE      gender = 2 AND stud_year = 2 AND A.COURSE_CODE = TMP.COURSE_CODE) AS f2,
                          (SELECT     COUNT(GENDER)
                            FROM          dbo.VW_SUMMARY TMP
                            WHERE      gender = 1 AND stud_year = 3 AND A.COURSE_CODE = TMP.COURSE_CODE) AS m3,
                          (SELECT     COUNT(GENDER)
                            FROM          dbo.VW_SUMMARY TMP
                            WHERE      gender = 2 AND stud_year = 3 AND A.COURSE_CODE = TMP.COURSE_CODE) AS f3,
                          (SELECT     COUNT(GENDER)
                            FROM          dbo.VW_SUMMARY TMP
                            WHERE      gender = 1 AND stud_year = 4 AND A.COURSE_CODE = TMP.COURSE_CODE) AS m4,
                          (SELECT     COUNT(GENDER)
                            FROM          dbo.VW_SUMMARY TMP
                            WHERE      gender = 2 AND stud_year = 4 AND A.COURSE_CODE = TMP.COURSE_CODE) AS f4,
                          (SELECT     COUNT(GENDER)
                            FROM          dbo.VW_SUMMARY TMP
                            WHERE      gender = 1 AND stud_year = 5 AND A.COURSE_CODE = TMP.COURSE_CODE) AS m5,
                          (SELECT     COUNT(GENDER)
                            FROM          dbo.VW_SUMMARY TMP
                            WHERE      gender = 2 AND stud_year = 5 AND A.COURSE_CODE = TMP.COURSE_CODE) AS f5,
                          (SELECT     COUNT(GENDER)
                            FROM          dbo.VW_SUMMARY TMP
                            WHERE      gender = 1 AND A.COURSE_CODE = TMP.COURSE_CODE) AS mt,
                          (SELECT     COUNT(GENDER)
                            FROM          dbo.VW_SUMMARY TMP
                            WHERE      gender = 2 AND A.COURSE_CODE = TMP.COURSE_CODE) AS ft
FROM         dbo.VW_SUMMARY A
GROUP BY COURSE_CODE