SQL

Natural language to SQL query generation evaluates text-to-query fidelity and schema reasoning. This task is particularly relevant for analytics chat assistants and simplified database interfaces.

Duration

Input Tokens

1016

Output Tokens

149

Cost

$0.00

Context

Input

Create a new table where I can store how much we pay instructors each month.

Expected output

CREATE TABLE instructor_payouts ( instructor_id INT REFERENCES users(user_id), payout_month DATE, amount DECIMAL(10, 2), PRIMARY KEY (instructor_id, payout_month) );

Model output

CREATE TABLE instructor_monthly_payments (
    payout_id SERIAL PRIMARY KEY,
    instructor_id INT NOT NULL REFERENCES users(user_id),
    payout_year INT NOT NULL,
    payout_month INT NOT NULL CHECK (payout_month BETWEEN 1 AND 12),
    amount DECIMAL(10, 2) NOT NULL CHECK (amount >= 0),
    paid_at TIMESTAMP DEFAULT NOW(),
    notes TEXT,
    UNIQUE (instructor_id, payout_year, payout_month)
);