example_strings.py

example1 = ["""CREATE TABLE stadium (
    stadium_id number,
    location text,
    name text,
    capacity number,
    highest number,
    lowest number,
    average number
)

CREATE TABLE singer (
    singer_id number,
    name text,
    country text,
    song_name text,
    song_release_year text,
    age number,
    is_male others
)

CREATE TABLE concert (
    concert_id number,
    concert_name text,
    theme text,
    stadium_id text,
    year text
)

CREATE TABLE singer_in_concert (
    concert_id number,
    singer_id text
)""",
"Using valid SQLite, answer the following questions for the tables provided above.",
"What is the maximum, the average, and the minimum capacity of stadiums ?"]

example2 = ["""CREATE TABLE stadium (
    stadium_id number,
    location text,
    name text,
    capacity number,
)""",
"Using valid SQLite, answer the following questions for the tables provided above.",
"how many stadiums in total?"]

example3 = ["""CREATE TABLE work_orders (
    ID NUMBER,
    CREATED_AT TEXT,
    COST FLOAT,
    INVOICE_AMOUNT FLOAT,
    IS_DUE BOOLEAN,
    IS_OPEN BOOLEAN,
    IS_OVERDUE BOOLEAN,
    COUNTRY_NAME TEXT,
)""",
"Using valid SQLite, answer the following questions for the tables provided above.",
"how many work orders are open?"]