Skip to content

Instantly share code, notes, and snippets.

View nkay28's full-sized avatar

Nitin Kumar nkay28

View GitHub Profile
@nkay28
nkay28 / top_movies.sql
Created May 23, 2019 21:33 — forked from pamelafox/top_movies.sql
Top 100 Movies
/* 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
/*
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,