TasksData and SQLEngineering track

Data cleanup migration

eng-sql-04suite v1.0sql

Quality20%judge panel
Correctness65%deterministic · sqlite-compare
Completeness15%judge panel

Exact prompt sent to every model

The clients table contains duplicate clients created by an import: same name ignoring case and surrounding whitespace, different ids. Write a SQLite migration script that: keeps the oldest client row per normalized name, repoints matters and invoices from duplicates to the keeper, deletes the duplicates, adds a UNIQUE index on the normalized name to prevent recurrence, and wraps everything in a transaction. Do not use vendor-specific extensions. Return only the SQL.

Responses

Latest published run: gemini-3.8-flash. For each model the repeat closest to its published median is shown; every repeat is in the repository.

No published attempts for this task yet

When the run is published, every model's raw response, per-dimension scores, judge rationales, human review notes and rendered artifacts appear here side by side.

Data cleanup migration (eng-sql-04) | XOBENCH