Showing posts with label database queries. Show all posts
Showing posts with label database queries. Show all posts

Thursday, July 08, 2010

What's in a Title?

Just for a bit of fun, I queried my euro crime database to see what the most popular title names are. There are nearly 9000 titles (so far) in the work in progress that is the (soon to be back in Access, hurrah) database. Two titles were repeated 5 times and 11 appear 4 times. I've restricted my post to these top two places.

Here are the more frequently used titles:
5 Times

Killing Time
Missing

4 Times

Angel of Death
Betrayal
Blood Ties
Cold Blood
Deadline
Innocent Blood
Last Rites
Nemesis
Requiem
Vanishing Point
Written in Blood
A few more statistics: 196 titles have "blood" in them, 567 have "death", 443 have "murder" but only 66 have "crime" and 57 have "mystery" in them.