-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathexamples.txt
293 lines (252 loc) · 7.65 KB
/
examples.txt
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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
<question>
Question: What is the highest closing price recorded in the table?
</question>
<SQLQuery>
SQLQuery: SELECT MAX(Close) FROM apple_daily;
</SQLQuery>
<question>
Question: How many records are there in the table?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(*) FROM apple_daily;
</SQLQuery>
<question>
Question: What is the average volume of the stocks traded?
</question>
<SQLQuery>
SQLQuery: SELECT AVG(Volume) FROM apple_daily;
</SQLQuery>
<question>
Question: What is the date and time of the first recorded entry?
</question>
<SQLQuery>
SQLQuery: SELECT MIN(Date), MIN(Time) FROM apple_daily;
</SQLQuery>
<question>
Question: What is the range of the stock prices (difference between highest and lowest)?
</question>
<SQLQuery>
SQLQuery: SELECT MAX(High) - MIN(Low) FROM apple_daily;
</SQLQuery>
<question>
Question: What is the lowest closing price recorded in the table?
</question>
<SQLQuery>
SQLQuery: SELECT MIN(Close) FROM apple_daily;
</SQLQuery>
<question>
Question: How many distinct dates are there in the table?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(DISTINCT Date) FROM apple_daily;
</SQLQuery>
<question>
Question: What is the average high price for the month of January?
</question>
<SQLQuery>
SQLQuery: SELECT AVG(High) FROM apple_daily WHERE strftime('%m', Date) = '01';
</SQLQuery>
<question>
Question: What is the total number of records for the year 2021?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(*) FROM apple_daily WHERE strftime('%Y', Date) = '2021';
</SQLQuery>
<question>
Question: What is the highest opening price recorded in the table?
</question>
<SQLQuery>
SQLQuery: SELECT MAX(Open) FROM apple_daily;
</SQLQuery>
<question>
Question: How many distinct months are there in the table?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(DISTINCT strftime('%m', Date)) FROM apple_daily;
</SQLQuery>
<question>
Question: What is the average low price for the month of February?
</question>
<SQLQuery>
SQLQuery: SELECT AVG(Low) FROM apple_daily WHERE strftime('%m', Date) = '02';
</SQLQuery>
<question>
Question: What is the highest closing price recorded in the year 2023?
</question>
<SQLQuery>
SQLQuery: SELECT MAX(Close) FROM apple_daily WHERE strftime('%Y', Date) = '2023';
</SQLQuery>
<question>
Question: How many records are there for the month of March?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(*) FROM apple_daily WHERE strftime('%m', Date) = '03';
</SQLQuery>
<question>
Question: What is the highest closing price recorded on January 15th?
</question>
<SQLQuery>
SQLQuery: SELECT MAX(Close) FROM apple_daily WHERE strftime('%m-%d', Date) = '01-15';
</SQLQuery>
<question>
Question: How many records are there for the month of February in the year 2023?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(*) FROM apple_daily WHERE strftime('%Y-%m', Date) = '2023-02';
</SQLQuery>
<question>
Question: How many records are there for the day 02-15?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(*) FROM apple_daily WHERE strftime('%m-%d', Date) = '02-15';
</SQLQuery>
<question>
Question: How many records are there for the day 08-31?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(*) FROM apple_daily WHERE strftime('%m-%d', Date) = '08-31';
</SQLQuery>
<question>
Question: How many records are there for the day 10-10?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(*) FROM apple_daily WHERE strftime('%m-%d', Date) = '10-10';
</SQLQuery>
<question>
Question: How many records are there for the day 05-20 with a volume greater than 1 million?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(*) FROM apple_daily WHERE strftime('%m-%d', Date) = '05-20' AND Volume > 1000000;
</SQLQuery>
<question>
Question: How many records are there for the day 05-20 with a volume greater than 1 million?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(*) FROM apple_daily WHERE strftime('%m-%d', Date) = '05-20' AND Volume > 1000000;
</SQLQuery>
<question>
Question: I want the first five records and their Date and Time.
</question>
<SQLQuery>
SQLQuery: SELECT Date, Time FROM apple_daily LIMIT 5;
</SQLQuery>
<question>
Question: Question: What are the first 10 records in the table?
</question>
<SQLQuery>
SQLQuery: SELECT * FROM apple_daily LIMIT 10;
</SQLQuery>
<question>
Question: Give me the closing price of records that have a Date greater than 2023-12-18.
</question>
<SQLQuery>
SQLQuery: SELECT Close FROM apple_daily WHERE Date >= '2023-12-18';
</SQLQuery>
<question>
Question: How many distinct years are there in the table?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(DISTINCT strftime('%Y', Date)) FROM apple_daily;
</SQLQuery>
<question>
Question: What are the average high prices for records before the date '2023-01-11'? (Include the values from that date)
</question>
<SQLQuery>
SQLQuery: SELECT AVG(High) FROM apple_daily WHERE Date <= '2023-01-11';
</SQLQuery>
<question>
Question: What is the highest closing price recorded on a Monday?
</question>
<SQLQuery>
SQLQuery: SELECT MAX(Close) FROM apple_daily WHERE strftime('%w', Date) = '1';
</SQLQuery>
<question>
Question: What is the average low price for records with a closing price between 100 and 200?
</question>
<SQLQuery>
SQLQuery: SELECT AVG(Low) FROM apple_daily WHERE Close BETWEEN 100 AND 200;
</SQLQuery>
<question>
Question: How many records are there for the day 07-04 with an opening price less than 150?
</question>
<SQLQuery>
SQLQuery: SELECT COUNT(*) FROM apple_daily WHERE strftime('%m-%d', Date) = '07-04' AND Open < 150;
</SQLQuery>
<question>
Question: What is the average volume of the stocks traded on a Sunday?
</question>
<SQLQuery>
SQLQuery: SELECT AVG(Volume) FROM apple_daily WHERE strftime('%w', Date) = '0';
</SQLQuery>
<question>
Question: What is the highest opening price recorded on a Friday?
</question>
<SQLQuery>
SQLQuery: SELECT MAX(Open) FROM apple_daily WHERE strftime('%w', Date) = '5';
</SQLQuery>
<question>
Question: What is the average high price for records on a Wednesday?
</question>
<SQLQuery>
SQLQuery: SELECT AVG(High) FROM apple_daily WHERE strftime('%w', Date) = '3';
</SQLQuery>
<question>
Question: I want to export the data
</question>
<SQLQuery>
SQLQuery: SELECT export data;
</SQLQuery>
<question>
Question: Could you give me a file with the data retreived so far?
</question>
<SQLQuery>
SQLQuery: SELECT export data;
</SQLQuery>
<question>
Question: Give me a csv with the results
</question>
<SQLQuery>
SQLQuery: SELECT export data;
</SQLQuery>
<question>
Question: Please give me the file with the queries results
</question>
<SQLQuery>
SQLQuery: SELECT export data;
</SQLQuery>
<question>
Question: I want to export the csv
</question>
<SQLQuery>
SQLQuery: SELECT export data;
</SQLQuery>
<question>
Question: Export csv
</question>
<SQLQuery>
SQLQuery: SELECT export data;
</SQLQuery>
<question>
Question: What's the average value of the columns Close and Volume in the table apple_daily?
</question>
<SQLQuery>
SQLQuery: SELECT AVG(Close), AVG(Volume) FROM apple_daily;
</SQLQuery>
<question>
Question: Which is the max value of the columns Open and Close?
</question>
<SQLQuery>
SQLQuery: SELECT MAX(Open), MAX(Close) FROM apple_daily;
</SQLQuery>
<question>
Question: What's the average value of every column?
</question>
<SQLQuery>
SQLQuery: SELECT AVG(Date), AVG(Time), AVG(Open), AVG(High), AVG(Low), AVG(Close), AVG(Volume) FROM apple_daily;
</SQLQuery>
<question>
Question: What's the min value of columns Open and Close?
</question>
<SQLQuery>
SQLQuery: SELECT MIN(Open), MIN(Close) FROM apple_daily;
</SQLQuery>