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.
Instant access
Commercial use
Money‑backBy purchasing this prompt, you agree to our terms of service
6
Favorites
884
Views
TEXT-DAVINCI-003
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
Added over 1 month ago
