展开全部
1.CREATE DATABASE stuinfo
2.USE stuinfo
CREATE TABLE student (Id INT PRIMARY KEY,
Name VARCHAR(10) NOT NULL,
Gender CHAR(4) NOT NULL,
Age INT NOT NULL,
Grade INT)
3.INSERT INTO dbo.student (Id,
Name,
Gender,
Age,
Grade)
VALUES (1, '小明', '男', 18, 74),
(2, '小红', '女', 18, 86),
(3, '小花', '女', 19, 85),
(4, '小刚', '男', 18, 92),
(5, '小强', '男', 17, 60),
(6, '翠花', '女', 19, 77)
4.ALTER TABLE dbo.student ADD classid INT
5.UPDATE dbo.student SET classid = 1 WHERE Id IN ( 1, 2, 3 )
UPDATE dbo.student SET classid = 2 WHERE Id IN ( 4, 5, 6 )
6.DELETE FROM dbo.studen WHERE Name LIKE '%花%'
7.SELECT s.Gender, AVG(s.Grade) 平均32313133353236313431303231363533e58685e5aeb931333431353932grade
FROM dbo.student s
GROUP BY s.Gender