top_programs.sql

top_programs.sql

/*
16 of the top programs on Khan Academy.
Collected by: https://www.khanacademy.org/profile/TKA23/
*/
CREATE TABLE top_programs (
	id INTEGER PRIMARY KEY,
	name TEXT,
	creator Text,
	votes INTEGER,
	spin_offs INTEGER);

INSERT INTO top_programs VALUES (1, "The Ultimate TD", "The #1 Base 12 Proponent",7649, 4686);
INSERT INTO top_programs VALUES (2, "doodle jump", "nordituck",5239, 5351);
INSERT INTO top_programs VALUES (3, "Cut The Rope", "Khan Ace",4935, 1774);
INSERT INTO top_programs VALUES (4, "Interactive iPhone 5c", "Mustafa Mian",4161, 1840);
INSERT INTO top_programs VALUES (5, "Mini Putt", "Matt",3983, 2427);
INSERT INTO top_programs VALUES (6, "Duck Life", "Kevin23",3691, 3041);
INSERT INTO top_programs VALUES (7, "Book Of Jokes 2", "Proto",3656, 608);
INSERT INTO top_programs VALUES (8, "Flappy Bird", "Kazza++",3463, 4096);
INSERT INTO top_programs VALUES (9, "Mario V.2", "Radioactive",3228, 1599);
INSERT INTO top_programs VALUES (10, "Lava, The Impossible Game", "Swax97",2945, 1822);
INSERT INTO top_programs VALUES (11, "How I Hacked onto Oh Noes", "Robert Monroe",2718, 362);
INSERT INTO top_programs VALUES (12, "The Button", "jzhoujin",2611, 175);
INSERT INTO top_programs VALUES (13, "Zombie Invasion", "Ethan #29 Canvas Size Proponent",2549, 1578);
INSERT INTO top_programs VALUES (14, "Falling Pixel", "JstuffJr",2357, 1811);
INSERT INTO top_programs VALUES (15, "Flappy Bird", "Kevin23",2127, 3378);
INSERT INTO top_programs VALUES (16, "Infinity Hall", "Ben F",1756, 470);