{"log_fixture":"req_id=1 latency_ms=120\nreq_id=2 latency_ms=980\nreq_id=3 latency_ms=150\nreq_id=4 latency_ms=200","parsing_or_query_code":"import sqlite3\nconn = sqlite3.connect(':memory:')\nc = conn.cursor()\nc.execute('CREATE TABLE logs(req_id INTEGER, latency_ms INTEGER)')\nfor line in lines:\n    req_id = int(line.split()[0].split('=')[1])\n    lat = int(line.split()[1].split('=')[1])\n    c.execute('INSERT INTO logs VALUES (?, ?)', (req_id, lat))\nc.execute(\"SELECT AVG(latency_ms) FROM logs\")\nresult = round(c.fetchone()[0], 2)","query_language":"SQL (log data loaded into a table)","expected_extracted_metrics":"362.5"}