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 …