1,151
edits
AI2sql (ChatGPT Plugin): Difference between revisions
no edit summary
No edit summary |
Startledcat (talk | contribs) No edit summary |
||
| Line 18: | Line 18: | ||
===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. | #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. | #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]'. | #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. | #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. | #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'. | #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. | #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. | #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. | #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. | #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== | ||