如何通过3列区分行并获取排序行

I have following table,

我有下表,

       sc_title      |      sc_date        | sc_coursecode | sc_courseno | sc_courseyear
------------------------------------------------------------------------------------------
    Open Water Diver | 2015-01-08 04:00:00 |       ow      |    05W      |    2015
    Open Water Diver | 2015-03-08 04:00:00 |       ow      |    05Z      |    2015
    Open Water Diver | 2015-04-08 04:00:00 |       ow      |    05W      |    2015
    Open Water Diver | 2015-05-18 04:00:00 |       ow      |    05W      |    2015
    Open Water Diver | 2015-05-09 04:00:00 |       ow      |    05Z      |    2015
    Open Water Diver | 2015-05-10 04:00:00 |       ow      |    05W      |    2015
    Open Water Diver | 2015-05-11 04:00:00 |       ow      |    05Z      |    2015
    Open Water Diver | 2015-05-12 04:00:00 |       ow      |    07W      |    2015
    Open Water Diver | 2015-05-13 04:00:00 |       ow      |    05Z      |    2015
    Open Water Diver | 2015-05-14 04:00:00 |       ow      |    07W      |    2015
    Open Water Diver | 2016-05-15 04:00:00 |       ow      |    07C      |    2016
        Bubble Maker | 2015-05-16 04:00:00 |       ow      |    07C      |    2015
       sc_tit