练习:
题目:查询数据表中2门以及以上不及格的人的平均成绩
创建语句:
create table scores2(
id int primary key auto_increment,
name varchar(20),
subject varchar(20),
marks int
)default charset utf8;
数据集
insert into scores2 values(1,'张三','语文',50);
insert into scores2 values(null,'张三','数学',60);
insert into scores2 values(null,'张三','英语',70);
insert into scores2 values(null,'张三','历史',80);
insert into scores2 values(null,'张三','体育',90);
insert into scores2 values(null,'李四','语文',40);
insert into scores2 values(null,'李四','数学',30);
insert into scores2 values(null,'李四','英语',70);
insert into scores2 values(null,'李四','历史',80);
insert into scores2 values(null,'李四&