两表连查

两表连查

1.首先创建库
create database csone charset=utf8;
2.打开库
use csone;
3.创建Account表
create table Account(
-> id int not null,
-> name varchar(255),
-> class varchar(255));
创建Exam表
create table Account(
-> id int not null,
-> name varchar(255),
-> class varchar(255));
4.在可视化软件添加数据


5.写两表连查的SQL语句
第一种：（1）select a.class,e.course,AVG(e.score) from account a,exam e where a.id=e.aid GROUP BY a.class,e.course
第二种（2）select Account.Class ‘班级’,exam.Coures ‘考试科目’,AVG(score) '班级平均分’from account join exam on account.ID = exam.AID GROUP BY account.Class,exam.Coures