新手一枚,使用mysql 5.7.21.
最近在找练习题做,遇到一难题,束手无策了已经,现跪求各路大神指点一二.以下是表格结构及记录.
create table st(id int(4) primary key not null,
name varchar(20) not null,
class varchar(10),
age int(10),
literture int(30),
mathemtics int(30)
);
insert into st values
(208,'泰瑞宝','07-25',19,98,59),
(209,'旺德福','07-25',28,48,114),
(210,'我太富','07-25',31,93,123),
(211,'黑宾','07-25',22,101,79),
(212,'苟无敬','07-25',24,118,90),
(213,'刘奶','07-25',23,67,79),
(218,'李问','07-23',19,108,77),
(219,'王说','07-20',28,78,99),
(220,'侯启娥','07-23',31,63,101),
(22