Shows in Which Panelists Have the Same First Initial

Each of the panelists on the panel for the Wait Wait… Don’t Tell Me! show that aired on 2016-04-02 shared something in common: all three of their first initials were “A” (Adam, Amy and Alonzo). When my mind latched onto that, I started wondering if this was the first time something like that happened; or, was it a more common occurrence?

So, I opened up my SQL management tool of choice and started working out the queries to get the information that I needed.

The first query was to pull in all of the data from the show and panelist related tables and grab the first letter of the panelist names (first initial); then, I had to group the instances of the first initials together and only show the results that have a common panelist first initial count of 3. The query also filtered out any shows that were either repeats or Best Of shows. The latter could spoil the results due to having more than three panelists recorded.

Shows Where Panelists Have Same First Initial - Query 1
Getting list of shows where all three panelists have the same first initial

The resulting output of the query kind of surprised me. Out of the 850 shows that have been taped (again, excluding repeats and Best Of shows), there have only been three instances in which all three panelists had the same first initial. Using that list of show dates, I crafted a simple query to list the names of the panelists for those three shows.

Shows Where Panelists Have Same First Initial - Query 2
Getting list of panelists based on previous list of shows

The first instance was back in 2004-09-04, in which Roxanne Roberts, Richard Roeper, and Roy Blount, Jr. were on the panel. The next instance happened seven years later on 2011-09-03, in which Amy Dickinson, Adam Felber, and Alonzo Bodden were on the panel. The same set of panelists then appeared on the 2016-04-02 show.

While running these queries and getting ready to write this blog post, I wanted to see what the distribution of panelists first initials looked like, and I ran the following query:

Distribution of Panelists First Initials
Distribution of Panelists First Initials

From the results, there are nine panelists with a first initial of “A” (Aamer Haleem, Adam Burke, Adam Felber, Alison Stewart, Alonzo Bodden, Amy Dickinson, Andrea Michaels, Angela Nissel, and Aparna Nancherla), seven with a first initial of “P” (P.J. O’Rourke, Patt Morrison, Paul Provenza, Paula Pell, Paula Poundstone, Peter Grosz, and Peter Sagal), six with a first initial of “M” (Margo Kaufman, Marina Franklin, Maz Jobrani, Mike Birbiglia, Mo Rocca, and Moshe Kasher), five with a first initial of “K” (Karen Grigsby Bates, Keegan-Michael Key, Ken Jennings, Ken Rudin, and Kyrie O’Connor), and five with a first initial of “R” (Reza Aslan, Richard Roeper, Rosie Perez, Roxanne Roberts, and Roy Blount, Jr.).

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.