* You are viewing the archive for September, 2009

National Leaders Professions and University Degrees

I’m going to take a look at the professions and university degrees of national leaders and see if anything interesting comes out.
Notes :
I looked at the leader of a country on the 19th day of the 9th month of the 9th year of every decade.

The countries I included were United States, United Kingdom, China, Australia, France and India.

For India I thought it reasonable to include prime ministers since independance, starting with
Nehru in 1949.

The Chinese history was by far the most confusing. There have been presidents,
Chairmen of the Communist Party, General Secretaries and … Continue Reading

How do you determine what should be a primary key?

My thought process in determining a primary key goes like this.

“One record in this table will represent …?”

Continue Reading

Youtube’s Most Viewed Videos

I’m going to take a look at the 25 most viewed videos on youtube, just for fun, to see if anything interesting comes out.
Notes :
The youtube data I am looking at is from the 8th of September 2009.
The Location setting was ‘WorldWide’.  You will see a different list of ‘Most Views’ videos if your Location setting is for your specific country, which I believe it is by default.

#
posted date
Title
Views Num
Comments Num
Video Responses Num
Category
User

1
4-Jun-2006
Evolution of Dance link
125,567,407
392,010
1550
Comedy
judsonlaipply

2
27-Feb-2007
Avril Lavigne – Girlfriend … Continue Reading