Database information:

- database keeps track of the history of the teams that each player has played on

- team number, manager number, team name, coach number, and player number are unique attributes across the league

- database keeps track of the history of all the coaching duties that each coach has performed

- Managers are treated separate from coaches. Manager history is not tracked. There is a one to one relationship between team and manager but a team does not have to have a manager.

- serial number (for bats) is unique only for a team

- in the affiliation table, the AffilYrs attribute indicates the number of years that a player played on a team; the batting average is for the years that a player played on a team.

- The WORKEXPERIENCE table keeps track of each coach's work history with teams. The WEXPCurrent field indicates which is the coach's current coaching job. A coach can only hold the same position with a team once.

Queries:

1. List all team names of teams that currently do not have a manager.

2. List all player names who are older than 24, and their associated current team name. Only include players who are currently active.

3. List the names of all players who have played for more than five years with their current team. 4. List the team names and cities and the number of current players each has. List the results alphabetically by team name.