- Count number of games ending won during over-time. Group by teams.
- List all game events in a specific game.
- List all game events from a specific period in a game.
- List all goals scored by the home team in a specific game along with the name of the scoring players.
- Get the play sequence that preceded a specific goal.
- For all penalties in a game, list the person who drew the penalty, the penalty type and the penalty time.
- For a given time point, return the manpower differential (MD).
- Generate the context for a specific action event get the context (i.e., Shulte), including the GD (Goal Differential), MD (Manpower Differential) and P (Period).
For all players in a specific season, answer the following questions:
- Get the number of games played for a team in a season (GP). not solved yet
- Get the total points for a team in a season (TP). not solved yet
- Get the number of goals for a team in a season (G). not solved yet
- Get the number of plus-minus (+/-) of a team not solved yet
- Get the number of goals against (GA) of a team not solved yet
- Get the number of goals (G).
- Get the number of assists (A).
- Get the total points (TP).
- Get the number of game-winning goals (GWG).
- Get the number of powerplay goals (PPG).
- Get the number of hits.
- Get the total penalty minutes (PIM).
- Get the number of games played (GP).
- Get the time on ice (TOI) not solved yet
- Get the number of plus-minus (+/-) of a skater not solved yet
- Get the number of shots on goal (SOG).
- Get the number of goals against (GA) of a goaltender not solved yet
- Get the number of goals-against average (GAA=GA*60/TOI) not solved yet
- Get the number of shot saved (SVS) of a goaltender not solved yet
- Get the number of save percentage (SVS%=SVS/SOG) not solved yet