my tables

-- create
CREATE TABLE Gamer (
gameID INTEGER PRIMARY KEY,
name TEXT NOT NULL,
Job TEXT NOT NULL
);

CREATE TABLE Newsreporter (
newsID INTEGER PRIMARY KEY,
name TEXT NOT NULL,
Job TEXT NOT NULL
);

CREATE TABLE editor (
editorID INTEGER PRIMARY KEY,
name TEXT NOT NULL,
Job TEXT NOT NULL
);

CREATE TABLE youtuber (
youtuberID INTEGER PRIMARY KEY,
name TEXT NOT NULL,
Job TEXT NOT NULL
);

-- insert
INSERT INTO Gamer VALUES (13211, 'Urdarkboy', 'Gamerboi');
INSERT INTO Gamer VALUES (13234, 'Yuvanthpremnath', 'Gamerboi');
INSERT INTO Gamer VALUES (23478, 'clownpierce_777', 'Gamerboi');
INSERT INTO Gamer VALUES (13235, 'joshuapremnath', 'Gamerboi');
INSERT INTO Gamer VALUES (23244, 'militaryman3', 'Gamerboi');

INSERT INTO Newsreporter VALUES (23476, 'jack flanderson', 'Newsreporter');
INSERT INTO Newsreporter VALUES (24579, 'Anderson Cooper', 'Newsreporter');
INSERT INTO Newsreporter VALUES (29090, 'David Muir', 'Newsreporter');
INSERT INTO Newsreporter VALUES (29190, 'Robin Roberts', 'Newsreporter');
INSERT INTO Newsreporter VALUES (29140, 'Christiane Amanpour', 'Newsreporter');

INSERT INTO editor VALUES (12311, 'Paul Rogers', 'editor');
INSERT INTO editor VALUES (12321, 'Joe Walker', 'editor');
INSERT INTO editor VALUES (87867, 'Mikkel', 'editor');
INSERT INTO editor VALUES (12386, 'Michael McCusker', 'editor');
INSERT INTO editor VALUES (12334, 'Andrew Buckland', 'editor');

INSERT INTO youtuber VALUES (13234, 'beckbrojack', 'youtuber');
INSERT INTO youtuber VALUES (13273, 'aCookiegod', 'youtuber');
INSERT INTO youtuber VALUES (13897, 'Eystreem', 'youtuber');
INSERT INTO youtuber VALUES (13677, 'Xnextiro', 'youtuber');
INSERT INTO youtuber VALUES (13567, 'craftee', 'youtuber');

select * from youtuber