面试题中的一个行转列问题

将下标显示成右边的形式，列转行的使用。

SELECT

       name,

       MAX(

              CASE

              WHEN week='1' THEN

                     course

              END

       )as '星期一',

       MAX(

              CASE

              WHEN week='2' THEN

                     course

              END

       )as '星期二',

       MAX(

              CASE

              WHEN week='3' THEN

                     course

              END

       )as '星期三',

       MAX(

              CASE

              WHEN week='4' THEN

                     course

              END

       )as '星期四',

       MAX(

              CASE

              WHEN week='5' THEN

                     course

              END

       )as '星期五'

FROMteacher