CREATETABLE sys_student (
id INT,
name VARCHAR(10),
is_male TINYINT,# 1:男、0:女
chinese DECIMAL(4,1),
math DECIMAL(4,1),
english DECIMAL(4,1));CREATETABLE sys_class(
id INT,
name VARCHAR(10));
一、 聚合函数SELECT COUNT(id) FROM sys_student; #统计数量SELECT MAX(math) FROM sys_student; #最大值SELECT MIN(math) FROM sys_student; #最小值SELECT SUM(mant) FROM sys_student; ...