Adding the pipeline_tag as Text Generation
#1
by
ErgodicEntropy
- opened
README.md
CHANGED
@@ -5,57 +5,71 @@ license: llama2
|
|
5 |
model_creator: NumbersStation
|
6 |
model_name: NSQL Llama-2 7B
|
7 |
model_type: llama
|
8 |
-
prompt_template:
|
9 |
-
|
10 |
|
11 |
SELECT
|
12 |
-
|
13 |
-
'
|
14 |
quantized_by: TheBloke
|
15 |
widget:
|
16 |
- example_title: Number stadiums
|
17 |
-
text:
|
18 |
-
|
19 |
-
|
20 |
-
|
21 |
-
|
22 |
-
|
23 |
-
FLOAT, IS_DUE BOOLEAN, IS_OPEN BOOLEAN, IS_OVERDUE BOOLEAN, COUNTRY_NAME TEXT,
|
24 |
)
|
25 |
|
26 |
|
27 |
-
-- Using valid SQLite, answer the following questions for the tables
|
28 |
-
above.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
29 |
|
30 |
|
31 |
-- how many work orders are open?
|
32 |
|
33 |
|
34 |
-
SELECT
|
35 |
- example_title: Stadium capacity
|
36 |
-
text:
|
|
|
37 |
number, highest number, lowest number, average number )
|
38 |
|
39 |
|
40 |
-
CREATE TABLE singer ( singer_id number, name text, country text, song_name
|
41 |
-
song_release_year text, age number, is_male others )
|
42 |
|
43 |
|
44 |
-
CREATE TABLE concert ( concert_id number, concert_name text, theme text,
|
45 |
-
text, year text )
|
46 |
|
47 |
|
48 |
CREATE TABLE singer_in_concert ( concert_id number, singer_id text )
|
49 |
|
50 |
|
51 |
-
-- Using valid SQLite, answer the following questions for the tables
|
52 |
-
above.
|
53 |
|
54 |
|
55 |
-- What is the maximum, the average, and the minimum capacity of stadiums ?
|
56 |
|
57 |
|
58 |
-
SELECT
|
|
|
59 |
---
|
60 |
<!-- markdownlint-disable MD041 -->
|
61 |
|
@@ -475,4 +489,4 @@ print(tokenizer.decode(generated_ids[0], skip_special_tokens=True))
|
|
475 |
|
476 |
For more information (e.g., run with your local database), please find examples in [this repository](https://github.com/NumbersStationAI/NSQL).
|
477 |
|
478 |
-
<!-- original-model-card end -->
|
|
|
5 |
model_creator: NumbersStation
|
6 |
model_name: NSQL Llama-2 7B
|
7 |
model_type: llama
|
8 |
+
prompt_template: |
|
9 |
+
{prompt}
|
10 |
|
11 |
SELECT
|
|
|
|
|
12 |
quantized_by: TheBloke
|
13 |
widget:
|
14 |
- example_title: Number stadiums
|
15 |
+
text: >-
|
16 |
+
CREATE TABLE stadium (
|
17 |
+
stadium_id number,
|
18 |
+
location text,
|
19 |
+
name text,
|
20 |
+
capacity number,
|
|
|
21 |
)
|
22 |
|
23 |
|
24 |
+
-- Using valid SQLite, answer the following questions for the tables
|
25 |
+
provided above.
|
26 |
+
|
27 |
+
|
28 |
+
-- how many stadiums in total?
|
29 |
+
|
30 |
+
|
31 |
+
SELECT
|
32 |
+
- example_title: Open work orders
|
33 |
+
text: >-
|
34 |
+
CREATE TABLE work_orders ( ID NUMBER, CREATED_AT TEXT, COST FLOAT,
|
35 |
+
INVOICE_AMOUNT FLOAT, IS_DUE BOOLEAN, IS_OPEN BOOLEAN, IS_OVERDUE BOOLEAN,
|
36 |
+
COUNTRY_NAME TEXT, )
|
37 |
+
|
38 |
+
|
39 |
+
-- Using valid SQLite, answer the following questions for the tables
|
40 |
+
provided above.
|
41 |
|
42 |
|
43 |
-- how many work orders are open?
|
44 |
|
45 |
|
46 |
+
SELECT
|
47 |
- example_title: Stadium capacity
|
48 |
+
text: >-
|
49 |
+
CREATE TABLE stadium ( stadium_id number, location text, name text, capacity
|
50 |
number, highest number, lowest number, average number )
|
51 |
|
52 |
|
53 |
+
CREATE TABLE singer ( singer_id number, name text, country text, song_name
|
54 |
+
text, song_release_year text, age number, is_male others )
|
55 |
|
56 |
|
57 |
+
CREATE TABLE concert ( concert_id number, concert_name text, theme text,
|
58 |
+
stadium_id text, year text )
|
59 |
|
60 |
|
61 |
CREATE TABLE singer_in_concert ( concert_id number, singer_id text )
|
62 |
|
63 |
|
64 |
+
-- Using valid SQLite, answer the following questions for the tables
|
65 |
+
provided above.
|
66 |
|
67 |
|
68 |
-- What is the maximum, the average, and the minimum capacity of stadiums ?
|
69 |
|
70 |
|
71 |
+
SELECT
|
72 |
+
pipeline_tag: text-generation
|
73 |
---
|
74 |
<!-- markdownlint-disable MD041 -->
|
75 |
|
|
|
489 |
|
490 |
For more information (e.g., run with your local database), please find examples in [this repository](https://github.com/NumbersStationAI/NSQL).
|
491 |
|
492 |
+
<!-- original-model-card end -->
|