Skip to main content
Toolathlon-Verified · Website task ID 142 · Canonical task game-statistics View the task source at d57361c0

​
Required Tools

MCP Servers
google-cloud
terminal
Local Tools
python_execute
claim_done
handle_overlong_tool_outputs
manage_context
history

​
Instruction

The end-of-day settlement time for the game has arrived, and we need to process the player score data for the current day in the daily_scores_stream table. First, generate the final leaderboard for the day by selecting the top 100 players with the highest scores and storing the results in an independent table named after the day’s date, leaderboard_YYYYMMDD(Must include player_id, total_score and rank fields). Second, for long-term player behavior analysis, update the statistical data for all players on the day into the master table player_historical_stats, inserting a new record for each player containing their ID, the day’s date, the day’s total score, and the number of games played on the day.

​
Initial State

​
Runtime Setup

This task initializes application or service state during preprocessing. Review the pinned setup source.

​
Legacy Trajectories

These replays were produced on the original Toolathlon release. They are retained for historical inspection and are not Toolathlon-Verified results.