Skip to content

Instantly share code, notes, and snippets.

Pamela Fox pamelafox

Block or report user

Report or block pamelafox

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View earned_badges.sql
/*
Earned Badges
This table contains badges earned by a user, including the most recent date achieved, the type, the name, the # of energy points earned, and the activity earned from.
Collected by: https://www.khanacademy.org/profile/chopsor/
*/
CREATE TABLE badges (
date TEXT,
badge_type TEXT,
badge_name TEXT,
View furniture_store_sales.sql
/*
Sales from an online furniture store
Collected by: https://www.khanacademy.org/profile/charlesb2000/
*/
CREATE TABLE sales(
ID INTEGER NOT NULL PRIMARY KEY
, transaction_date TEXT
, product TEXT
, price INTEGER
, payment_type TEXT
View marvel_characters.sql
/* Marvel Heroes and Villains
Based on the website http://marvel.wikia.com/Main_Page
with popularity data from http://observationdeck.io9.com/something-i-found-marvel-character-popularity-poll-cb-1568108064
and power grid data from http://marvel.wikia.com/Power_Grid#Power
Collected by: https://www.khanacademy.org/profile/Mentrasto/
*/
CREATE TABLE marvels (ID INTEGER PRIMARY KEY,
name TEXT,
popularity INTEGER,
View human_organs.sql
/*
Top 10 organs in the human body, by weight
Adapted from: https://propelsteps.wordpress.com/2014/10/12/know-top-10-largest-organs-of-the-human-body/
Collected by: https://www.khanacademy.org/profile/errorbuddy/
*/
CREATE TABLE organs (id INTEGER PRIMARY KEY,
name TEXT,
weight INTEGER,
important_functions TEXT,
View 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);
View solar_system_objects.sql
/*
Solar system objects
Adapted from: http://en.wikipedia.org/wiki/List_of_Solar_System_objects_by_size
Collected by: https://www.khanacademy.org/profile/patrick809/programs
*/
CREATE TABLE solar_system_objects(
body TEXT
, mean_radius NUMERIC /* km */
, mean_radius_rel NUMERIC /* relative to earth */
, volume NUMERIC /* 10^9 km^3 */
View ka_avatars.sql
/*
Khan Academy Avatars:
This table contains all of Khan Academy's avatars, including their type and name, the requirements to unlock them, and their relative image URL.
Collected by:
https://www.khanacademy.org/profile/chopsor/
*/
CREATE TABLE avatars (
id INTEGER,
View countries_by_population.sql
/*
Top 100 Countres By Population, 2014
Collected by https://www.khanacademy.org/profile/darrylyeo/
Data adapted from
http://www.worldometers.info/world-population/population-by-country/
*/
CREATE TABLE countries_by_population (
rank INTEGER PRIMARY KEY AUTOINCREMENT,
country TEXT,
@pamelafox
pamelafox / jeopardy.sql
Created Apr 29, 2015
Jeopardy Questions
View jeopardy.sql
CREATE TABLE jeopardy(
ID INTEGER NOT NULL PRIMARY KEY
, Show_Number INTEGER
, Air_Date TEXT
, Round TEXT
, Category TEXT
, Value TEXT
, Question TEXT
, Answer TEXT
);
View top_movies.sql
/* Source: http://www.boxofficemojo.com/alltime/world/ */
CREATE TABLE top_movies(
rank TEXT NOT NULL PRIMARY KEY
, title TEXT
, studio TEXT
, worldwide TEXT
, domestic_money TEXT
, domestic_percent TEXT
, overseas_money TEXT
You can’t perform that action at this time.