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

event

event_id (TEXT) PK
event_name (TEXT)
event_date (TEXT)
type (TEXT)
notes (TEXT)
location (TEXT)
status (TEXT)

major

major_id (TEXT) PK
major_name (TEXT)
department (TEXT)
college (TEXT)

zip_code

zip_code (INTEGER) PK
type (TEXT)
city (TEXT)
county (TEXT)
state (TEXT)
short_state (TEXT)

attendance

link_to_event (TEXT) PK
link_to_member (TEXT) PK

budget

budget_id (TEXT) PK
category (TEXT)
spent (REAL)
remaining (REAL)
amount (INTEGER)
event_status (TEXT)
link_to_event (TEXT)

expense

expense_id (TEXT) PK
expense_description (TEXT)
expense_date (TEXT)
cost (REAL)
approved (TEXT)
link_to_member (TEXT)
link_to_budget (TEXT)

income

income_id (TEXT) PK
date_received (TEXT)
amount (INTEGER)
source (TEXT)
notes (TEXT)
link_to_member (TEXT)

member

member_id (TEXT) PK
first_name (TEXT)
last_name (TEXT)
email (TEXT)
position (TEXT)
t_shirt_size (TEXT)
phone (TEXT)
zip (INTEGER)
link_to_major (TEXT)