CSCI 250 - Table Example (SQL Statements)

CREATE TABLE NameTable (StudentID INTEGER, LastName TEXT, FirstName TEXT)
INSERT INTO NameTable VALUES (123, 'Doe', 'John')
INSERT INTO NameTable VALUES (124, 'Doe', 'Jane')
INSERT INTO NameTable VALUES (125, 'Jones', 'John')
CREATE TABLE CourseTable (StudentID INTEGER, Course TEXT)
INSERT INTO CourseTable VALUES (123, 'CSCI 250')
INSERT INTO CourseTable VALUES (123, 'MATH 240')
INSERT INTO CourseTable VALUES (123, 'MATH 130')
INSERT INTO CourseTable VALUES (124, 'CSCI 150')
INSERT INTO CourseTable VALUES (124, 'HIST 110')