SQL Explorer
Demo Environment
This environment resets nightly. Any data or connections you add are public.
SQL Explorer
New Query
Playground
Connections
Logs
Favorites
Prompt length analysis
Title
default
tq
base
history_1390634-1970-01-01-MAX_1.db
RMS
179146-Activity_2024-07-12_07-47_101208779_1.db
job_summary_1.db
vehicles_1.db
job_skills_1.db
IMDbMovies-Clean_1.db
sqlite-sakila.db
northwind.db
transactions_1.db
organizations-100000_1.db
maestro-v3.0.0_1.db
job_postings_1.db
Connection
What is the average lenght of prompts? How much variability is there?
Description
SQL
WITH LengthStats AS ( SELECT AVG(LENGTH(prompt)) AS mean_length, AVG(LENGTH(prompt) * LENGTH(prompt)) - AVG(LENGTH(prompt)) * AVG(LENGTH(prompt)) AS variance FROM explorer_promptlog ) SELECT mean_length AS average_length, SQRT(variance) AS length_variability FROM LengthStats;
Save & Run
Save Only
Download...
CSV
JSON
Show Schema
Hide Schema
Format
SQL Assistant
Assistant prompt
"Ask Assistant" to try and automatically fix the issue. The assistant is already aware of error messages & context.
Select All
(?)
Search tables
Ask Assistant
Loading...
Preview
Pivot
  Execution time: 8.80 ms
Showing
of 1 total rows.
average_length
length_variability
Sum
1970.07
Avg
1970.07
Min
1970.07
Max
1970.07
NUL
0.0
Sum
2199.96
Avg
2199.96
Min
2199.96
Max
2199.96
NUL
0.0
0
1970.0681818181818182
2199.96205440134469691003305783135472
Link to this
Download CSV
Avg. execution: 9.317ms. Query created by admin on 2024-05-17.
History