• Do what Jeff said but replace

    PARTITION BY StudentName

    With

    PARTITION BY SubjectName


    Dird