CREATE TABLE Student_Roll (
  Roll_No PRIMARY KEY,
  Name INTEGER,
  Address Address,
  Phone Phone,
  Age Age
);

-- insert some values
INSERT INTO Student_Roll VALUES ('1', 'Harsh', 'Delhi', 'XXXXXXXXXX', '18');
INSERT INTO Student_Roll VALUES ('2', 'Pratik', 'Birah', 'XXXXXXXXXX', '19');
INSERT INTO Student_Roll VALUES ('3', 'Riyanka', 'Siliguri', 'XXXXXXXXXX', '20');
INSERT INTO Student_Roll VALUES ('4', 'Deep', 'Ramnagar', 'XXXXXXXXXX', '18');
INSERT INTO Student_Roll VALUES ('5', 'Saptarhi', 'Kolkata', 'XXXXXXXXXX', '19');
INSERT INTO Student_Roll VALUES ('6', 'Dhanraj', 'Barabajah', 'XXXXXXXXXX', '20');
INSERT INTO Student_Roll VALUES ('7', 'Rohit', 'Balurghat', 'XXXXXXXXXX', '18');
INSERT INTO Student_Roll VALUES ('8', 'Niraj', 'Alipur', 'XXXXXXXXXX', '19');

-- fetch some values
SELECT * FROM Student_Roll;



-- create a table
CREATE TABLE Student_Course (
  Course_ID INTEGER,
  Roll_No PRIMARY KEY
);

-- insert some values
INSERT INTO Student_Course VALUES ('1', '1');
INSERT INTO Student_Course VALUES ('2', '2');
INSERT INTO Student_Course VALUES ('2', '3');
INSERT INTO Student_Course VALUES ('3', '4');
INSERT INTO Student_Course VALUES ('1', '5');
INSERT INTO Student_Course VALUES ('4', '9');
INSERT INTO Student_Course VALUES ('5', '10');
INSERT INTO Student_Course VALUES ('4', '11');

-- fetch some values
SELECT Course_ID FROM Student_Course;

SELECT Student_Course.Course_ID,Student_Roll.Name,Student_Roll.Age FROM Student_Roll
inner join Student_Course on Student_Roll.Roll_No=Student_Course.Roll_No;