Generate Incorrect SQL Queries

Create Query

Database

These are your uploaded SQLite databases.

Query Selection

Select from existing queries or create your own.

Natural Language Query

Correct SQL Query

Error Strategies

Join Errors

Filtering Errors

Aggregation Errors

Selection Errors

Subquery Errors

Set Operation Errors

Sorting Errors

Syntax Logic Errors

Limit Offset Errors

Select which types of errors to generate.

Min Errors

Max Errors

Note: Generation can take 10-30 seconds depending on the complexity of the query. The process will:

Get database schema and sample data
Generate incorrect SQL variants using GPT-4o
Validate each incorrect query by executing it against the database
Save results for viewing

Database Schema

frpm

CDSCode (TEXT) PK
Academic Year (TEXT)
County Code (TEXT)
District Code (INTEGER)
School Code (TEXT)
County Name (TEXT)
District Name (TEXT)
School Name (TEXT)
District Type (TEXT)
School Type (TEXT)
Educational Option Type (TEXT)
NSLP Provision Status (TEXT)
Charter School (Y/N) (INTEGER)
Charter School Number (TEXT)
Charter Funding Type (TEXT)
IRC (INTEGER)
Low Grade (TEXT)
High Grade (TEXT)
Enrollment (K-12) (REAL)
Free Meal Count (K-12) (REAL)
Percent (%) Eligible Free (K-12) (REAL)
FRPM Count (K-12) (REAL)
Percent (%) Eligible FRPM (K-12) (REAL)
Enrollment (Ages 5-17) (REAL)
Free Meal Count (Ages 5-17) (REAL)
Percent (%) Eligible Free (Ages 5-17) (REAL)
FRPM Count (Ages 5-17) (REAL)
Percent (%) Eligible FRPM (Ages 5-17) (REAL)
2013-14 CALPADS Fall 1 Certification Status (INTEGER)

satscores

cds (TEXT) PK
rtype (TEXT)
sname (TEXT)
dname (TEXT)
cname (TEXT)
enroll12 (INTEGER)
NumTstTakr (INTEGER)
AvgScrRead (INTEGER)
AvgScrMath (INTEGER)
AvgScrWrite (INTEGER)
NumGE1500 (INTEGER)

schools