Musql 多表

use student

CREATE TABLE Account(ID INT(11),name VARCHAR(255),class VARCHAR(255))
select * from Account;

INSERT INTO account VALUES
(1,“小米”,“高三二班”)
,(2,“小花”,“高三一班”)
,(3,“小段”,“高三二班”)
,(4,“小西”,“高三一班”)
,(5,“小北”,“高三一班”)
,(6,“小绿”,“高三二班”)
,(7,“小红”,“高三一班”)

CREATE TABLE Exam(id INT,course VARCHAR(255),Score INT,Aid INT)
select * from Exam;
INSERT INTO Exam VALUES
(1,“英语”,99,1),
(2,“语文”,89,1),
(3,“数学”,49,1),
(4,“语文”,79,1),
(5,“英语”,69,1),
(6,“数学”,89,1),
(7,“英语”,59,1)

Select a.class,e.course,e.score from account a,Exam e where a.id=e.aid
SELECT a.class,e.course,AVG(e.score) from account a,Exam e where a.id=e.aid GROUP BY a.class,e.course