mysql如何从两个表取出内容_如何从mysql中的两个表中获取数据？

我必须找出输出作为每个班级的班级名称和学生人数？我的两张桌子是 –

CREATE TABLE student(Fields_ID INT, Name VARCHAR(20));

INSERT INTO student(Fields_ID,Name) VALUES(30,'JYOTI');

INSERT INTO student(Fields_ID,Name) VALUES(31,'KIRTI');

INSERT INTO student(Fields_ID,Name) VALUES(32,'YOGITA');

INSERT INTO student(Fields_ID,Name) VALUES(33,'RASHMI');

INSERT INTO student(Fields_ID,Name) VALUES(34,'NUPUR');

SELECT * FROM student;

CREATE TABLE class(Fields_ID INT, Name VARCHAR(20));

INSERT INTO class(Fields_ID,Name) VALUES(30,'FIRST');

INSERT INTO class(Fields_ID,Name) VALUES(31,'SECOND');

INSERT INTO class(Fields_ID,Name) VALUES(32,'THIRD');

INSERT INTO class(Fields_ID,Name) VALUES(33,'FOURTH');

INSERT INTO class(Fields_ID,Name) VALUES(34,'FIFTH');

SELECT * FROM class;

我试图从以下代码返回所需的内容,但它不会返回相同的内容.

知道为什么它没有返回正确的值.我是MySql的初学者所以我无法找出问题所在.

SELECT class.Name , COUNT(student.name)

From class INNER JOIN student

ON class.Fields_ID=student.Fields_ID;