1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 CREATE TABLE tb_Class( classid int NOT NULL IDENTITY, classname NVARCHAR(16) NOT NULL, students int NOT NULL, teacher NVARCHAR(16) NOT NULL, PRIMARY KEY(classid)) INSERT INTO tb_Class(classname,students,
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
CREATE TABLE tb_Class(
classid int NOT NULL IDENTITY,
classname NVARCHAR(16) NOT NULL,
students int NOT NULL,
teacher NVARCHAR(16) NOT NULL,
PRIMARY KEY(classid))
INSERT INTO tb_Class(classname,students,teacher)
VALUES
('1班',25,'yl'),('2班',18,'wsp'),('3班',24,'yl'),('4班',25,'zhy'),
('5班',22,'wsp'),('6班',25,'yl'),('7班',20,'zhy'), ('8班',22,'wsp')
SELECT SUM(students) FROM tb_Class GROUP BY teacher
SELECT COUNT(students) FROM tb_Class GROUP BY teacher
SELECT AVG(students) FROM tb_Class GROUP BY teacher
SELECT MAX(students) FROM tb_Class GROUP BY teacher
SELECT MIN(students) FROM tb_Class GROUP BY teacher
，
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
广告Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
202
收藏
