1. For each individual award presented to a manager, return the following columns:
a. ID of individual award,b. Year of individual award,
c. Player first and last name,
d. Manager ID,
e. Name of the managed team for that manager and year

2. For each player who has been inducted to the hall of fame, return the following columns:
a. Player last name,
b. Player first name,
c. Year inducted to the hall of fame,
d. School atteneded by that player

3. For each player/award combination, return the following columns:
a. Player last name
b. Player first name
c. Player school name
d. Individual award id
e. Individual award year
Include players who have never won an individual award and players who have not gone to school. Return more than one row for players who have won more than one award.

4. For every person inducted into the hall of fame, return the following columns:
a. Last name
b. First name
NOTE: Both managers and players can be inducted into the hall of fame.

5. Return the following columns for each player:
a. Player last name
b. Player first name
c. number of individual awards for that player
Only include players who have won at least 3 awards
6. For each school, return the following columns:
a. School name
b. School city
c. School state
d. Number of players from this school
Only include schools that have had at least 5 players

7. Return the following columns for each player:
a. Player last nameb. Player first name
c. total batting.HR (Home runs) for that player over their career
Only include players with a total batting.HR over 50

8. Return the following columns for each player:
a. Player last name
b. Player first name
c. total pitching.GS (Games Started) for that player over their career
Only include players with a total pitching.GS between 5 and 10

9. For each team, return the following columns
a. Team name
b. Year ID
c. Lowest salary offered by per team, per year

10. Return the following information for each player:
a. Player last name
b. Player first name
c. Total career individual Most Valuable Player wins
d. Total career shared MVP awards