johko/NSQL-Text-To-SQL

1example1 = ["""CREATE TABLE stadium (2    stadium_id number,3    location text,4    name text,5    capacity number,6    highest number,7    lowest number,8    average number9)10 11CREATE TABLE singer (12    singer_id number,13    name text,14    country text,15    song_name text,16    song_release_year text,17    age number,18    is_male others19)20 21CREATE TABLE concert (22    concert_id number,23    concert_name text,24    theme text,25    stadium_id text,26    year text27)28 29CREATE TABLE singer_in_concert (30    concert_id number,31    singer_id text32)""",33"Using valid SQLite, answer the following questions for the tables provided above.",34"What is the maximum, the average, and the minimum capacity of stadiums ?",35"nsql-6B"]36 37example2 = ["""CREATE TABLE stadium (38    stadium_id number,39    location text,40    name text,41    capacity number,42)""",43"Using valid SQLite, answer the following questions for the tables provided above.",44"how many stadiums in total?",45"nsql-2B"]46 47example3 = ["""CREATE TABLE work_orders (48    ID NUMBER,49    CREATED_AT TEXT,50    COST FLOAT,51    INVOICE_AMOUNT FLOAT,52    IS_DUE BOOLEAN,53    IS_OPEN BOOLEAN,54    IS_OVERDUE BOOLEAN,55    COUNTRY_NAME TEXT,56)""",57"Using valid SQLite, answer the following questions for the tables provided above.",58"how many work orders are open?",59"nsql-350M"]60