CREATE TABLE S (
StudentID INTEGER,
StudentName TEXT,
Course TEXT
);
INSERT INTO S VALUES (1, 'Alice', 'Math');
INSERT INTO S VALUES (1, 'Alice', 'Science');
INSERT INTO S VALUES (2, 'Bob', 'History');
INSERT INTO S VALUES (3, 'Charlie', 'Math');
INSERT INTO S VALUES (3, 'Charlie', 'History');
INSERT INTO S VALUES (3, 'Charlie', 'Science');
SELECT DISTINCT StudentID, StudentName INTO U FROM S;
SELECT DISTINCT StudentID, Course INTO V FROM S;
SELECT * FROM S;
SELECT * FROM U;
SELECT * FROM V;
SELECT U.StudentID, U.StudentName, V.Course
FROM U INNER JOIN V ON U.StudentID = V.StudentID; 41