Players per team above a jersey number

The input file jersey.txt holds a single integer J, a jersey number threshold.

For each team, count how many of its players have a jersey_no greater than or equal to J. Only include teams that have at least one such player.

Output one row per team, ordered alphabetically by team name. Each row has two columns:

1. the team name
2. the number of its players with jersey_no >= J

Columns are separated by a single space.

Note: Do not hard-code the database name — your program is run against a different database instance for evaluation. The input file is in the same folder as your program.

For the database connection, use these variables:

database = sys.argv[1]   # database name, from the command line
user     = os.environ.get('PGUSER')
password = os.environ.get('PGPASSWORD')
host     = os.environ.get('PGHOST')
port     = os.environ.get('PGPORT')

The input is a file named jersey.txt in the same folder — A single integer jersey-number threshold, e.g. 10..

---

Database: FLIS

−+Fit
primary keyforeign keyarrow points to the referenced columndrag to pan