PromptBase
🤖 GPT
Looking to complete your stack as a data analyst ? Already got skills in data visualization ? Complete your skillset by overcoming the inability to code sql. Why learn to code SQL when you can use this prompt to generate the query that you can use
Simply describle the objective of task and the prompt will automatically generate the SQL code with explanation for each line of code proposed
...more
$3.99
After purchasing, you will gain access to the prompt file which you can use with GPT or the app builder. You'll receive 20 free generation credits with this purchase. By purchasing this prompt, you agree to our terms of service.
Over 1 month ago
Prompt Details
Model
Completion - GPT-3.5 (text-davinci-003)
Token size
225 ($0.00450 / call)
Example input
Example Input
In my sql table named "film", there are columns named "film_id" , "title", "rating" and "length"
I would like to retrieve the film title with the shortest length
Example output
Example Output
'SQL Code:
SELECT title
FROM film
ORDER BY length ASC
LIMIT 1;
Explanation:
This code retrieves the film title with the shortest length from the film table.
The SELECT statement is used to retrieve the title from the film table.
The ORDER BY statement is used to order the results in ascending order by length.
The LIMIT statement is used to limit the results to the first row or top row, which will be the film with the shortest length.