一个困惑了我很久的sql查询语句,请大家帮忙,感恩不敬!

declare @student table(sno varchar(10), name varchar(10))
insert into @student select 1, '张三'
insert into @student select 2, '李四'
insert into @student select 3, '王五'

declare @cours table(sno varchar(10), course varchar(10))
insert into @cours select 1, '美术'
insert into @cours select 1, '音乐'
insert into @cours select 1, '体育'
insert into @cours select 2, '语文'
insert into @cours select 2, '数学'

select a.sno, a.name, b.course
into #
from @student a, @cours b
where a.sno=b.sno

select
sno = case when course = (select top 1 course from # where sno = x.sno order by course)
then cast(sno as varchar(10)) else '' end,
name = case when course = (select top 1 course from # where name = x.name order by course)
then cast(name as varchar(10)) else '' end,
course
from # as x
order by sno*1,cours