SELECT happiness FROM world;
I have found an interesting post in Hannibal’s blog (not Lecter, Barca himself) about happiness in the world; there was a link to the World Map happiness, according to a British psychologist.
The page, however, only shows countries classified by their alphabetic order, and not happiness rank. Lazy as I am, I did a quick and dirty Perl script to insert the data into an sqlite 3 database, so that I can rank them according to any criteria. I don’t know how did the researcher proceed, there are some paradoxes: Bhutan came in the 8th place, outpassing Norway, New Zealand, Belgium, … and of course, the United States!
Here is the gzip compressed SQLite3 database, and here’s the compressed query text.
Don’t worry … Be happy …
August 4th, 2006 at 1:32 pm
How can open your file ; view the results ?
August 4th, 2006 at 1:38 pm
you need to download sqlite3 (not 2!!), uncompress happiness.sqlite3.gz and run in commandline (both unix and dos)
sqlite3 happiness.sqlite3then make your query
SELECT * FROM happinessSpeak happiness …