I need 4 query tables created from the uploaded gdb. The queries are:
1. List the players based on the number of home runs hit in their rookie seasons (from high to low).
[login to view URL] the players by the number of seasons played (high to low). (Do not double-count in cases in which a player switched teams mid-season; i.e., 1987, which Sammy Sosa split between CHW and TEX should be counted as 1 season, not 2.)
[login to view URL] the players by their career batting average (career hits divided by career at-bats, high to low).
4,Sort the players by their number of seasons with 100 or more RBI (high to low).
Sort the players based on the number of years between their first and last 40+ HR season (high to low).