At the center of attention

Some people like to be in the spotlight and at the center of attention. (Ex-)President Trump is one of them. After reading an article on Politico, I found a link to a piece which showed the following very informative Venn-diagram.

Source: https://www.snopes.com/fact-check/trump-venn-diagram/

The diagram shows three intersecting cohorts of American presidents.

Trump is depicted in the center being the only president to fit all three cohort descriptions. The Venn diagram was shared by several prominent journalists and activists through several media.

If the data that are shown in the diagram would have been put in a relational database the query to get the American presidents out that are shown in the center, could look something like this.

SELECT 
  t.name AS three_time_loser
FROM 
  presidents_table AS t
WHERE 
  t.n_terms = 1 AND
  t.popular_vote = "LOST" AND
  t.remarkable_events IN ("IMPEACHED", "RESIGNED")
ORDER BY
  t.name ASC

For SQL-minded nerds like me, even writing this simple select statement brings a smile to my face.

  • content/at_the_center_of_attention.txt
  • Last modified: 2021/01/06 10:48