# bird-bench / card_games__412 - taskset: [bird-bench](https://harnessreport.com/tasks/bird-bench.md) - difficulty: medium - 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: What is the foreign name of the card in French of type Creature, normal layout and black border color, by artist Matthew D. Wilson? Evidence: in French refers to language = 'French'; black border color refers to borderColor = 'black' Schema: CREATE TABLE "cards" ( id INTEGER not null primary key autoincrement, artist TEXT, asciiName TEXT, availability TEXT, borderColor TEXT, cardKingdomFoilId TEXT, cardKingdomId TEXT, colorIdentity TEXT, colorIndicator TEXT, colors TEXT, convertedManaCost REAL, duelDeck TEXT, edhrecRank INTEGER, faceConvertedManaCost REAL, faceName TEXT, flavorName TEXT, flavorText TEXT, frameEffects TEXT, frameVersion TEXT, hand TEXT, hasAlternativeDeckLimit INTEGER default 0 not null, hasContentWarning INTEGER default 0 not null, hasFoil INTEGER default 0 not null, hasNonFoil INTEGER default 0 not null, isAlternative INTEGER default 0 not null, isFullArt INTEGER default 0 not null, isOnlineOnly INTEGER default 0 not null, isOversized INTEGER default 0 not null, isPromo INTEGER default 0 not null, isReprint INTEGER default 0 not null, isReserved INTEGER default 0 not null, isStarter INTEGER default 0 not null, isStorySpotlight INTEGER default 0 not null, isTextless INTEGER default 0 not null, isTimeshifted INTEGER default 0 not null, keywords TEXT, layout TEXT, leadershipSkills TEXT, life TEXT, loyalty TEXT, manaCost TEXT, mcmId TEXT, mcmMetaId TEXT, mtgArenaId TEXT, mtgjsonV4Id TEXT, mtgoFoilId TEXT, mtgoId TEXT, multiverseId TEXT, name TEXT, number TEXT, originalReleaseDate TEXT, originalText TEXT, originalType TEXT, otherFaceIds TEXT, power TEXT, printings TEXT, promoTypes TEXT, purchaseUrls TEXT, rarity TEXT, scryfallId TEXT, scryfallIllustrationId TEXT, scryfallOracleId TEXT, setCode TEXT, side TEXT, subtypes TEXT, supertypes TEXT, tcgplayerProductId TEXT, text TEXT, toughness TEXT, type TEXT, types TEXT, uuid TEXT not null unique, variations TEXT, watermark TEXT ) CREATE TABLE "foreign_data" ( id INTEGER not null primary key autoincrement, flavorText TEXT, language TEXT, multiverseid INTEGER, name TEXT, text TEXT, type TEXT, uuid TEXT references cards (uuid) ) CREATE TABLE "legalities" ( id INTEGER not null primary key autoincrement, format TEXT, status TEXT, uuid TEXT references cards (uuid) on update cascade on delete cascade ) CREATE TABLE "rulings" ( id INTEGER not null primary key autoincrement, date DATE, text TEXT, uuid TEXT references cards (uuid) on update cascade on delete cascade ) CREATE TABLE "set_translations" ( id INTEGER not null primary key autoincrement, language TEXT, setCode TEXT references sets (code) on update cascade on delete cascade, translation TEXT ) CREATE TABLE "sets" ( id INTEGER not null primary key autoincrement, baseSetSize INTEGER, block TEXT, booster TEXT, code TEXT not null unique, isFoilOnly INTEGER default 0 not null, isForeignOnly INTEGER default 0 not null, isNonFoilOnly INTEGER default 0 not null, isOnlineOnly INTEGER default 0 not null, isPartialPreview INTEGER default 0 not null, keyruneCode TEXT, mcmId INTEGER, mcmIdExtras INTEGER, mcmName TEXT, mtgoCode TEXT, name TEXT, parentCode TEXT, releaseDate DATE, tcgplayerGroupId INTEGER, totalSetSize INTEGER, type TEXT ) 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