Tool Call query_database

Tool Call Data

{
  "id": "2d2ba4c6-0fc4-40b6-8615-a537fc51362f",
  "toolName": "query_database",
  "inputParams": {
    "sql": "\nWITH dimir_match_results AS (\n  SELECT \n    te.id as entry_id,\n    te_opp.archetype_id as opp_archetype_id,\n    a.name as opp_archetype_name,\n    CASE \n      WHEN te.id = m.entry_id THEN m.result\n      ELSE CASE m.result\n        WHEN 'W' THEN 'L'\n        WHEN 'L' THEN 'W'\n        ELSE 'D'\n      END\n    END as dimir_result\n  FROM tournament_entries te\n  JOIN tournaments t ON te.tournament_id = t.id\n  JOIN matches m ON (te.id = m.entry_id OR te.id = m.opponent_entry_id)\n  JOIN tournament_entries te_opp ON \n    CASE \n      WHEN te.id = m.entry_id THEN m.opponent_entry_id = te_opp.id\n      ELSE m.entry_id = te_opp.id\n    END\n  JOIN archetypes a ON te_opp.archetype_id = a.id\n  WHERE te.archetype_id = '04142d50-8bf3-4c0c-bbc2-3ac6273ebbc6'\n    AND t.format_id = 'ceff9123-427e-4099-810a-39f57884ec4e'\n    AND t.date >= '2025-12-27'\n    AND t.date < '2026-01-27'\n    AND m.mirror = 0\n)\nSELECT \n  opp_archetype_name,\n  COUNT(*) as matches,\n  SUM(CASE WHEN dimir_result = 'W' THEN 1 ELSE 0 END) as wins,\n  SUM(CASE WHEN dimir_result = 'L' THEN 1 ELSE 0 END) as losses,\n  SUM(CASE WHEN dimir_result = 'D' THEN 1 ELSE 0 END) as draws,\n  ROUND(100.0 * SUM(CASE WHEN dimir_result = 'W' THEN 1 ELSE 0 END) / \n    (SUM(CASE WHEN dimir_result = 'W' THEN 1 ELSE 0 END) + SUM(CASE WHEN dimir_result = 'L' THEN 1 ELSE 0 END)), 1) as winrate_pct\nFROM dimir_match_results\nGROUP BY opp_archetype_id, opp_archetype_name\nHAVING matches >= 20\nORDER BY matches DESC\n"
  },
  "callId": "toolu_01NXNSeYgLERqqdgKLXD5Zpb",
  "title": null,
  "columnNames": null,
  "toolResult": null,
  "sessionId": "1cb4755b-3026-486b-a6b6-a788eccd5310",
  "messageId": "f7ba37c0-1ece-497d-a79a-625d64d573d8"
}