# bird-bench / european_football_2__1119 - taskset: [bird-bench](https://harnessreport.com/tasks/bird-bench.md) - difficulty: easy - category: database - language: - runnable from the site: no - agent timeout: 3600s ## Results by harness _none yet_ ## Instruction ``` You are given a natural language question and a SQLite database. Your task is to write a SQL query that answers the question. Database file: `/app/db.sqlite` You may use `sqlite3` or Python to inspect the schema and data. Do not modify the database. Question: How many home team goal have been scored by Aaron Lennon? Evidence: Aaron Lennon refers to player_name = 'Aaron Lennon' Schema: CREATE TABLE `Country` ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` TEXT UNIQUE ) CREATE TABLE `League` ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `country_id` INTEGER, `name` TEXT UNIQUE, FOREIGN KEY(`country_id`) REFERENCES `country`(`id`) ) CREATE TABLE "Match" ( id INTEGER primary key autoincrement, country_id INTEGER references Country, league_id INTEGER references League, season TEXT, stage INTEGER, date TEXT, match_api_id INTEGER unique, home_team_api_id INTEGER references Team (team_api_id), away_team_api_id INTEGER references Team (team_api_id), home_team_goal INTEGER, away_team_goal INTEGER, home_player_X1 INTEGER, home_player_X2 INTEGER, home_player_X3 INTEGER, home_player_X4 INTEGER, home_player_X5 INTEGER, home_player_X6 INTEGER, home_player_X7 INTEGER, home_player_X8 INTEGER, home_player_X9 INTEGER, home_player_X10 INTEGER, home_player_X11 INTEGER, away_player_X1 INTEGER, away_player_X2 INTEGER, away_player_X3 INTEGER, away_player_X4 INTEGER, away_player_X5 INTEGER, away_player_X6 INTEGER, away_player_X7 INTEGER, away_player_X8 INTEGER, away_player_X9 INTEGER, away_player_X10 INTEGER, away_player_X11 INTEGER, home_player_Y1 INTEGER, home_player_Y2 INTEGER, home_player_Y3 INTEGER, home_player_Y4 INTEGER, home_player_Y5 INTEGER, home_player_Y6 INTEGER, home_player_Y7 INTEGER, home_player_Y8 INTEGER, home_player_Y9 INTEGER, home_player_Y10 INTEGER, home_player_Y11 INTEGER, away_player_Y1 INTEGER, away_player_Y2 INTEGER, away_player_Y3 INTEGER, away_player_Y4 INTEGER, away_player_Y5 INTEGER, away_player_Y6 INTEGER, away_player_Y7 INTEGER, away_player_Y8 INTEGER, away_player_Y9 INTEGER, away_player_Y10 INTEGER, away_player_Y11 INTEGER, home_player_1 INTEGER references Player (player_api_id), home_player_2 INTEGER references Player (player_api_id), home_player_3 INTEGER references Player (player_api_id), home_player_4 INTEGER references Player (player_api_id), home_player_5 INTEGER references Player (player_api_id), home_player_6 INTEGER references Player (player_api_id), home_player_7 INTEGER references Player (player_api_id), home_player_8 INTEGER references Player (player_api_id), home_player_9 INTEGER references Player (player_api_id), home_player_10 INTEGER references Player (player_api_id), home_player_11 INTEGER references Player (player_api_id), away_player_1 INTEGER references Player (player_api_id), away_player_2 INTEGER references Player (player_api_id), away_player_3 INTEGER references Player (player_api_id), away_player_4 INTEGER references Player (player_api_id), away_player_5 INTEGER references Player (player_api_id), away_player_6 INTEGER references Player (player_api_id), away_player_7 INTEGER references Player (player_api_id), away_player_8 INTEGER references Player (player_api_id), away_player_9 INTEGER references Player (player_api_id), away_player_10 INTEGER references Player (player_api_id), away_player_11 INTEGER references Player (player_api_id), goal TEXT, shoton TEXT, shotoff TEXT, foulcommit TEXT, card TEXT, "cross" TEXT, corner TEXT, possession TEXT, B365H REAL, B365D REAL, B365A REAL, BWH REAL, BWD REAL, BWA REAL, IWH REAL, IWD REAL, IWA REAL, LBH REAL, LBD REAL, LBA REAL, PSH REAL, PSD REAL, PSA REAL, WHH REAL, WHD REAL, WHA REAL, SJH REAL, SJD REAL, SJA REAL, VCH REAL, VCD REAL, VCA REAL, GBH REAL, GBD REAL, GBA REAL, BSH REAL, BSD REAL, BSA REAL ) CREATE TABLE `Player` ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `player_api_id` INTEGER UNIQUE, `player_name` TEXT, `player_fifa_api_id` INTEGER UNIQUE, `birthday` TEXT, `height` INTEGER, `weight` INTEGER ) CREATE TABLE "Player_Attributes" ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `player_fifa_api_id` INTEGER, `player_api_id` INTEGER, `date` TEXT, `overall_rating` INTEGER, `potential` INTEGER, `preferred_foot` TEXT, `attacking_work_rate` TEXT, `defensive_work_rate` TEXT, `crossing` INTEGER, `finishing` INTEGER, `heading_accuracy` INTEGER, `short_passing` INTEGER, `volleys` INTEGER, `dribbling` INTEGER, `curve` INTEGER, `free_kick_accuracy` INTEGER, `long_passing` INTEGER, `ball_control` INTEGER, `acceleration` INTEGER, `sprint_speed` INTEGER, `agility` INTEGER, `reactions` INTEGER, `balance` INTEGER, `shot_power` INTEGER, `jumping` INTEGER, `stamina` INTEGER, `strength` INTEGER, `long_shots` INTEGER, `aggression` INTEGER, `interceptions` INTEGER, `positioning` INTEGER, `vision` INTEGER, `penalties` INTEGER, `marking` INTEGER, `standing_tackle` INTEGER, `sliding_tackle` INTEGER, `gk_diving` INTEGER, `gk_handling` INTEGER, `gk_kicking` INTEGER, `gk_positioning` INTEGER, `gk_reflexes` INTEGER, FOREIGN KEY(`player_fifa_api_id`) REFERENCES `Player`(`player_fifa_api_id`), FOREIGN KEY(`player_api_id`) REFERENCES `Player`(`player_api_id`) ) CREATE TABLE "Team" ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `team_api_id` INTEGER UNIQUE, `team_fifa_api_id` INTEGER, `team_long_name` TEXT, `team_short_name` TEXT ) CREATE TABLE `Team_Attributes` ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `team_fifa_api_id` INTEGER, `team_api_id` INTEGER, `date` TEXT, `buildUpPlaySpeed` INTEGER, `buildUpPlaySpeedClass` TEXT, `buildUpPlayDribbling` INTEGER, `buildUpPlayDribblingClass` TEXT, `buildUpPlayPassing` INTEGER, `buildUpPlayPassingClass` TEXT, `buildUpPlayPositioningClass` TEXT, `chanceCreationPassing` INTEGER, `chanceCreationPassingClass` TEXT, `chanceCreationCrossing` INTEGER, `chanceCreationCrossingClass` TEXT, `chanceCreationShooting` INTEGER, `chanceCreationShootingClass` TEXT, `chanceCreationPositioningClass` TEXT, `defencePressure` INTEGER, `defencePressureClass` TEXT, `defenceAggression` INTEGER, `defenceAggressionClass` TEXT, `defenceTeamWidth` INTEGER, `defenceTeamWidthClass` TEXT, `defenceDefenderLineClass` TEXT, FOREIGN KEY(`team_fifa_api_id`) REFERENCES `Team`(`team_fifa_api_id`), FOREIGN KEY(`team_api_id`) REFERENCES `Team`(`team_api_id`) ) Output: Write ONLY the SQL query to `/app/answer.sql`. Do not include code fences, comments, or explanations. ``` --- Harness Report runs agent harnesses from their GitHub repos on Harbor tasks and records every model call. Every page is also `.md` and `.json`; index: https://harnessreport.com/llms.txt · MCP: https://harnessreport.com/mcp