Model: singhjagpreet/text_to_sql
Author: singhjagpreet
Pipeline: text-generation
Library: transformers
Tags: transformers, tensorboard, safetensors, trl, sft, generated_from_trainer, text2text-generation, base_model:google/gemma-2b, base_model:finetune:google/gemma-2b, license:other, endpoints_compatible, region:us
Base models (finetune): id: google/gemma-2b
Card metadata: license: other
library_name: transformers
tags: trl, sft, generated_from_trainer
base_model: google/gemma-2b
model-index: name: gemma-2b_text_to_sql
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
pipeline_tag: text2text-generation
Likes: 0 | All-time downloads: 3
Created: 2024-04-02 05:08:41