CREATE TABLE Student(
  Id VARCHAR(10),
  Name VARCHAR(50),
  Age INT,
  Gender VARCHAR(1),
  Course VARCHAR(15));
INSERT INTO Student(id, name, Age, Gender, Course) VALUES ('1','Swathi','23','F','EEE');
INSERT INTO Student(id, name, Age, Gender, Course) VALUES ('2','Jyothi','22','F','ECE');
INSERT INTO Student(id, name, Age, Gender, Course) VALUES ('3','Harish','21','M','ME');
INSERT INTO Student(id, name, Age, Gender, Course) VALUES ('4','Akhi','25','F','CEE');
INSERT INTO Student(id, name, Age, Gender, Course) VALUES ('5','Maha','26','M','EEE');
INSERT INTO Student(id, name, Age, Gender, Course) VALUES ('6','Sudha','25','F','CSE');
SELECT * FROM Student;
CREATE TABLE Fee(
  Id VARCHAR(10),
  Name VARCHAR(50),
  Course VARCHAR(15),
  Amount_paid VARCHAR(20));
INSERT INTO Fee(id, name,  Course, Amount_paid) VALUES ('1','Manasa','EEE','20000');
INSERT INTO Fee(id, name,  Course, Amount_paid) VALUES ('2','Anu','ECE','15000');
INSERT INTO Fee(id, name,  Course, Amount_paid) VALUES ('3','Madhu','ME','6000');
INSERT INTO Fee(id, name,  Course, Amount_paid) VALUES ('4','Arun','CEE','9000');
INSERT INTO Fee(id, name,  Course, Amount_paid) VALUES ('5','Teja','EEE','13000');
INSERT INTO Fee(id, name, Course, Amount_paid) VALUES ('6','Praveen','CSE','6000');

SELECT Student.Id,Student.Name,Student.Course,Fee.Course,Fee.Amount_Paid FROM Student INNER JOIN FEE ON Student.Course=Fee.Course;