The input file member_class.txt contains one member class (the whole file content, stripped, is the value).
Using the members table joined to the quota table on member_type, consider only members whose member_class equals that value and compute: how many such members there are, and their total borrowing capacity (the sum of max_books across those members).
Output exactly one line with two values separated by a single space, in this order:
num_members total_max_books
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 member_class.txt in the same folder — One member class value (matches members.member_class)..
primary keyforeign keyarrow points to the referenced columndrag to pan