AI2sql (ChatGPT Plugin): Difference between revisions

From AI Wiki
m (Text replacement - "==Tips and Tricks==" to "==Tips and Tricks== ==Comments== <Comments />")
No edit summary
 
(7 intermediate revisions by 2 users not shown)
Line 4: Line 4:
|Platform = ChatGPT
|Platform = ChatGPT
|Model = GPT-4
|Model = GPT-4
|Category = Tech
|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 12: Line 12:
|Free =  
|Free =  
|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==
==Comments==
<Comments />
==Comments==
<Comments />
==Comments==
<Comments />


==Comments==
==Comments==
<Comments />
<Comments />

Latest revision as of 01:07, 24 June 2023

AI2sql (ChatGPT Plugin)
AI2sql.png
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:

  1. Write an SQL query to find the total revenue generated by a store from the 'sales' table.
  2. Create an SQL query to count the number of employees in each department from the 'employee_data' table.
  3. Generate an SQL query to update the email address of a user with the username 'jsmith' in the 'users' table to '[email protected]'.
  4. Construct an SQL query that retrieves all records with a price greater than 100 from the 'products' table, sorted in ascending order.
  5. 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.
  6. Provide an SQL query that deletes all records from the 'orders' table with a status of 'Cancelled'.
  7. Write an SQL query to get the average age of employees grouped by their job title from the 'company_staff' table.
  8. Construct an SQL query to find the top 10 best-selling products from the 'product_sales' table.
  9. Develop an SQL query to perform an inner join between the 'orders' table and the 'order_details' table, matching on the 'order_id' field.
  10. 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...