region -------------------------------------------------- Africa Bosnia and Herzegovina, Europe Central America and the Caribbean Commonwealth of Independent States Europe Middle East Oceania South America South America, Central America and the Caribbean (9 rows) name | area -----------------------------------+--------- Canada | 9976140 United States | 9629091 Mexico | 1972550 Saint Pierre and Miquelon | 242 Bermuda | 58 Brazil | 8511965 Argentina | 2766890 Peru | 1280000 Bolivia | 1098580 Chile | 756950 Paraguay | 406750 Ecuador | 283560 Guyana | 214970 Uruguay | 176220 Suriname | 163270 French Guiana | 91000 Falkland Islands (Islas Malvinas) | 12173 (17 rows) region | people --------------------------------------------------+------------ Asia | 2963031109 Africa | 793382933 Europe | 580590872 Southeast Asia | 561430334 North America | 407263424 South America | 283278882 Middle East | 180281538 Commonwealth of Independent States | 137195413 Central America and the Caribbean | 73193129 South America, Central America and the Caribbean | 63228304 Oceania | 30804740 Bosnia and Herzegovina, Europe | 3835777 World | 2301645 Arctic Region | 335090 Antarctic Region | 0 (15 rows) name | gdp ---------------+--------------- United States | 9255000000000 (1 row) name | density ------------------+---------------------- American Samoa | 328.8743718592964824 Aruba | 360.3056994818652850 Belgium | 335.6770239265814487 Guernsey | 330.3092783505154639 India | 308.4337818888608373 Japan | 334.9344978628237193 Lebanon | 344.0419230769230769 Marshall Islands | 376.3867403314917127 Martinique | 376.8327272727272727 Netherlands | 382.6504141384956178 Virgin Islands | 343.5142045454545455 West Bank | 344.7607508532423208 (12 rows) title | yr --------------------------------------+------ 1941 | 1979 Blues Brothers, The | 1980 Trading Places | 1983 Twilight Zone: The Movie | 1983 Indiana Jones and the Temple of Doom | 1984 Ghostbusters | 1984 Spies Like Us | 1985 Dragnet | 1987 My Stepmother Is an Alien | 1988 Caddyshack II | 1988 Great Outdoors, The | 1988 Ghostbusters II | 1989 Driving Miss Daisy | 1989 My Girl | 1991 Nothing But Trouble | 1991 Sneakers | 1992 Chaplin | 1992 Coneheads | 1993 Exit to Eden | 1994 Tommy Boy | 1995 Sgt. Bilko | 1996 Feeling Minnesota | 1996 My Fellow Americans | 1996 Grosse Pointe Blank | 1997 Antz | 1998 Blues Brothers 2000 | 1998 (26 rows) title | yr ---------------------+------ Spies Like Us | 1985 Caddyshack II | 1988 Nothing But Trouble | 1991 (3 rows) name ------------------ Annie Potts Bill Murray Dan Aykroyd David Margulies Ernie Hudson Harold Ramis Rick Moranis Sigourney Weaver (8 rows) title | releases --------------------------+---------- Cape Fear | 2 Frankenstein | 2 Hamlet | 2 Haunting, The | 2 Parent Trap, The | 2 Psycho | 2 Sabrina | 2 Screamers | 2 Shaft | 2 Thomas Crown Affair, The | 2 Three Musketeers, The | 2 (11 rows) title | original | remake --------------------------+----------+-------- Cape Fear | 1962 | 1991 Frankenstein | 1931 | 1994 Hamlet | 1990 | 1996 Haunting, The | 1963 | 1999 Parent Trap, The | 1961 | 1998 Psycho | 1960 | 1998 Sabrina | 1954 | 1995 Screamers | 1995 | 1995 Shaft | 1971 | 2000 Thomas Crown Affair, The | 1968 | 1999 Three Musketeers, The | 1973 | 1993 (11 rows)