-- 单表查询对应练习题 https://blog.csdn.net/ksaar_/article/details/103811410
-- 创建表
CREATE TABLE stu (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(32),
age int(11),
sex varchar(1),
address varchar(20),
math double(5, 2) NOT NULL DEFAULT 0.00,
english double(5, 2) NOT NULL DEFAULT 0.00,
PRIMARY KEY (id)
) AUTO_INCREMENT = 1;
-- 添加数据
INSERT INTO `stu` VALUES (1, '浩诚', 35, '女', '阿富汗', 90.00, 30.00);
INSERT INTO `stu` VALUES (2, '彭超', 20, '男', '阿富汗', 70.00, 60.00);
INSERT INTO `stu` VALUES (3, '余旭', 20, '男', '阿富汗', 50.00, 30.00);
INSERT INTO `stu` VALUES (4, '刘诚', 18, '女', '湖北', 90.00, 98.00);
INSERT INTO `stu` VALUES (5, '雨晴', 19, '女&#