CREATE TABLE student (
  name VARCHAR(50),
  registration INT,
  phone_number INT
);

INSERT INTO student (name, registration, phone_number)
VALUES ('aryan', 12222547, 8737539750),
('mohit', 1224857, 8775934878),
('rohit', 1232994, 8779879897),
('ashu', 122897, 8785656465);

CREATE TABLE fee (
  registration INT,
  total_fee FLOAT,
  fee_paid FLOAT,
  fee_due FLOAT
);

INSERT INTO fee (registration, total_fee, fee_paid, fee_due)
VALUES (12222547, 80000, 40000, 40000),
(1224857, 80000, 50000, 30000),
(1232994, 80000, 30000, 50000),
(122897, 120000, 70000, 50000);

SELECT s.name, s.registration, f.total_fee, f.fee_paid, f.fee_due
FROM student s
INNER JOIN fee f ON s.registration = f.registration;