AI2sql (ChatGPT Plugin): Difference between revisions
m (Text replacement - "|Available = yes" to "|Available = Yes") |
Startledcat (talk | contribs) No edit summary |
||
(5 intermediate revisions by 2 users not shown) | |||
Line 4: | Line 4: | ||
|Platform = ChatGPT | |Platform = ChatGPT | ||
|Model = GPT-4 | |Model = GPT-4 | ||
|Category = | |Category = Programming | ||
|Description = Converts a natural language text into an SQL query. | |Description = Converts a natural language text into an SQL query. | ||
|Third Party = | |Third Party = | ||
Line 13: | Line 13: | ||
|Price = | |Price = | ||
|Available = Yes | |Available = Yes | ||
|Working = Yes | |||
}} | }} | ||
==Guide== | ==Guide== | ||
===Example Prompts=== | ===Example Prompts=== | ||
Example prompts that utilize the plugin: | Example prompts that utilize the plugin: | ||
#Write an SQL query to find the total revenue generated by a store from the 'sales' table. | |||
#Create an SQL query to count the number of employees in each department from the 'employee_data' table. | |||
#Generate an SQL query to update the email address of a user with the username 'jsmith' in the 'users' table to '[email protected]'. | |||
#Construct an SQL query that retrieves all records with a price greater than 100 from the 'products' table, sorted in ascending order. | |||
#Convert this request to an SQL query: list all the names of students who scored above 90 in the subject 'Mathematics' from the 'exam_results' table. | |||
#Provide an SQL query that deletes all records from the 'orders' table with a status of 'Cancelled'. | |||
#Write an SQL query to get the average age of employees grouped by their job title from the 'company_staff' table. | |||
#Construct an SQL query to find the top 10 best-selling products from the 'product_sales' table. | |||
#Develop an SQL query to perform an inner join between the 'orders' table and the 'order_details' table, matching on the 'order_id' field. | |||
#Create an SQL query that adds a new column named 'last_name' with a data type of 'VARCHAR(50)' to the 'contact_info' table. | |||
==Tips and Tricks== | ==Tips and Tricks== |
Latest revision as of 01:07, 24 June 2023
AI2sql (ChatGPT Plugin) | |
---|---|
Information | |
Name | AI2sql |
Platform | ChatGPT |
Model | GPT-4 |
Category | Programming |
Description | Converts a natural language text into an SQL query. |
Release Date | May 28, 2023 |
Available | Yes |
Working | Yes |
AI2sql is a Plugin for ChatGPT.
Guide
Example Prompts
Example prompts that utilize the plugin:
- Write an SQL query to find the total revenue generated by a store from the 'sales' table.
- Create an SQL query to count the number of employees in each department from the 'employee_data' table.
- Generate an SQL query to update the email address of a user with the username 'jsmith' in the 'users' table to '[email protected]'.
- Construct an SQL query that retrieves all records with a price greater than 100 from the 'products' table, sorted in ascending order.
- Convert this request to an SQL query: list all the names of students who scored above 90 in the subject 'Mathematics' from the 'exam_results' table.
- Provide an SQL query that deletes all records from the 'orders' table with a status of 'Cancelled'.
- Write an SQL query to get the average age of employees grouped by their job title from the 'company_staff' table.
- Construct an SQL query to find the top 10 best-selling products from the 'product_sales' table.
- Develop an SQL query to perform an inner join between the 'orders' table and the 'order_details' table, matching on the 'order_id' field.
- Create an SQL query that adds a new column named 'last_name' with a data type of 'VARCHAR(50)' to the 'contact_info' table.
Tips and Tricks
Comments
Loading comments...