Model: NumbersStation/nsql-6B
Author: NumbersStation
Pipeline: text-generation
Library: transformers
Tags: transformers, pytorch, safetensors, codegen, text-generation, license:bsd-3-clause, endpoints_compatible, region:us
Card metadata: license: bsd-3-clause
inference: parameters: do_sample: no
max_length: 200
widget: text: 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?

SELECT
example_title: Number stadiums, text: 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?

SELECT
example_title: Open work orders, text: 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 ?

SELECT
example_title: Stadium capacity
Likes: 52 | All-time downloads: 6485
Created: 2023-07-04 01:37:53