USE test_wyy_db_guet
GO
SET NOCOUNT ON
-- ********** Begin ********** --
-- ********** 此处写第1题的SQL语句 ********** --
UPDATE student
SET sname = ltrim(rtrim(sname));
-- ********** End ********** --
GO
-- ********** Begin ********** --
-- ********** 此处写第2题的SQL语句 ********** --
UPDATE student
SET sname = rtrim(left(sname,2))+right(sname,1);
-- ********** End ********** --
GO
-- ********** Begin ********** --
-- ********** 此处写第3题的SQL语句 ********** --
UPDATE student
SET snative = CASE
WHEN snative LIKE '%族' THEN SUBSTRING(snative, 1, LEN(snative) - 1)
ELSE snative
END;
-- ********** End ********** --
GO
--下面语句请勿删除
SELECT * FROM student
GO
2. 一些实用的统计
USE test_wyy_db_guet
Go
SET NOCOUNT ON
-- ********** Begin ********** --
---------- 第一题----------
select snative,count(sno) from student group by snative;
-- ********** End ********** --
GO
-- ********** Begin ********** --
---------- 第二题----------
select sum(credit)
from course,(select distinct cno from sc)sc where course.cno = sc.cno;
-- ********** End ********** --
GO
-- ********** Begin ********** --
---------- 第三题----------
select cno,grade,count(sno) from sc group by cno,grade;
-- ********** End ********** --
GO