Tag Archives: SQL

From the “Pointless SQL Queries” file…

Somehow, the question came up on alt.usage.english of the distribution of author surnames (in people’s personal libraries) over the letters of the alphabet. Since I have a library database, I came up with the followng crazy query to answer this … Continue reading

Aside | Posted on by | Tagged

Fun with SQL: The U.S. city with the most AM stations

A friend asked me a radio trivia question with a surprising answer: what U.S. city has the most licensed AM radio stations? (This question had apparently stumped him when a friend asked him, and now he was trying to stump … Continue reading

Posted in Broadcasting & Media, Computing | Tagged , , ,

Simple database tricks

I’ve been keeping an inventory of my personal library in a database for more than a decade. It was thus easy, when writing the previous post, to find out the exact number of books I had bought from SFBC. I … Continue reading

Aside | Posted on by | Tagged