Exploring a baseball database

As part of the CodeCademy course ‘Design Databases With PostgreSQL’, I am getting oriented with databases by exploring this baseball database created by Sean Lahman.

The project from CodeCademy was to do various analyses on the data by creating sql queries. I found that it was pretty much above my sql skill level to create the queries on my own, so I ended up re-typing each query from the solutions file. I was able to read and understand the logic, though for joins involving multiple conditions the logic was difficult to wrap my head around. Also, I’m not super familiar with baseball.

After completing the assignment, I asked Claude.ai to create a SQL query to show the trend in average salaries for baseball players. I used the output to make this chart in Google sheets.