1)请编写sql语句对年龄进行升序排列
select * from a order by birth;
2)请编写sql语句查询对“徐”姓开头的人员名单
select * from a where name like ‘徐%’;
3)请编写sql语句修改“陈晓”的年龄为“45”
update a set age=45 where name=“陈晓”;
4)请编写sql删除王芳芳这表数据记录。
delete from afinfo where name=“王芳芳”;
5)新学生小明,学号为005,需要将信息写入学生信息表,SQL语句怎么编写?
insert into A values (“小明”,005);
1)李四语文成绩被登记错误,成绩实际为85分,更新到考试信息表中,SQL语句怎么编写?
update exam set score=85 where id=(select id from stu where name=“李四”) and subject=“语文”;
2)查询出各科成绩的平均成绩,显示字段为:学科、平均分,SQL怎么编写?
select subject,avg(score) from exam group by subject;
3)查询出所有学生各科成绩,显示字段为:姓名、学号、学科、成绩,并以学号与学科排序,没有成绩的学生也需要列出,SQL怎么编写?
select s.name,s.id,e.subject,e.score from stu s left join exam e on s.id=e.id order by i