Model: TheBloke/nsql-llama-2-7B-GGUF
Author: TheBloke
Library: transformers
Tags: transformers, gguf, llama, base_model:NumbersStation/nsql-llama-2-7B, base_model:quantized:NumbersStation/nsql-llama-2-7B, license:llama2, region:us
Base models (quantized): id: NumbersStation/nsql-llama-2-7B
Card metadata: base_model: NumbersStation/nsql-llama-2-7B
inference: no
license: llama2
model_creator: NumbersStation
model_name: NSQL Llama-2 7B
model_type: llama
prompt_template: {prompt}

SELECT

quantized_by: TheBloke
widget: example_title: Number stadiums
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: Open work orders
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: Stadium capacity
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
Likes: 8 | All-time downloads: 9055
Created: 2023-11-18 21:36:59