The Workload
A mix of queries and updates:
- Q1 (20%): given player id, return num and pos
- Q2 (40%): given player position, return names, nums
- Q3 (5%): retrieve player name, num, pos, and rink
- Q4 (10%): get W-L-T record of a team (given name, city)
- Q5 (10%): produce an alphabetical team listing
- Q6 (5%): list all rink names from smallest to largest
- U1 (10%): update W-L-T information