Data analysis of US baseball teams - Data Management & SQL - DAT-5486 course.
As a suggestion you can use MySQL Workbench to solve these exercises since it is a free and open source platform.
For MySQL to run locally on your laptop we need to install two applications: MySQL Server and MySQL Workbench
- Windows Users: https://downloads.mysql.com/archives/installer/ (Install version 8.0.26). Or MAC Users: https://downloads.mysql.com/archives/community/Links (download version 8.0.26).
- After that, install the workbench: https://dev.mysql.com/downloads/workbench/
I am not providing the database, however you can inspire in the queries I have used to answer related questions to answer similar questions using your own database.
-
Here you will find the solution for the following questions:
-
What is the % salary increase, on average, for a pitcher between 2018 and 2011?
-
Which team(s) have seen decreases in their total salary budgets across the years?
-
Which are players who have been around since 2009 with the same position?
-
Which players changed teams between 2018 and 2022?