create database CS
Use CS
create table Student(
Sid int identity(1,1) primary key,
Scourse varchar(50),
Sname varchar(50),
score int
)
select *from Student
drop table Student
select DISTINCT Scourse as’姓名’,
sum(case Sname when ‘数学’ then score end) as ‘数学’,
sum(case Sname when ‘语文’ then score end) as ‘语文’,
sum(case Sname when ‘英语’ then score end) as ‘英语’
from student GROUP BY Scourse