Spaces:
Sleeping
Sleeping
File size: 1,317 Bytes
7b065dc dd9e5f1 7b065dc df60fb6 dd9e5f1 7b065dc dd9e5f1 7b065dc df60fb6 dd9e5f1 7b065dc dd9e5f1 7b065dc df60fb6 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 |
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 ?",
"nsql-350M"]
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?",
"nsql-350M"]
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?",
"nsql-350M"]
|