Tag Archives: SQL

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 →

Posted on 2015-08-05 by Garrett Wollman | Comments Off on From the “Pointless SQL Queries” file…

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

Posted on 2014-03-27 by Garrett Wollman

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 , , , | Comments Off on Fun with SQL: The U.S. city with the most AM stations

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 →

Posted on 2013-09-28 by Garrett Wollman | Comments Off on Simple database tricks