How to Use
Last updated
Last updated
To get started with SQL Assistant, you will need to provide a Data Definition Language (DDL) segment and a task description.
DDL segment – a subset of SQL commands, objects, attributes, and constraints that is focused on defining or modifying the structure of database objects.
Task description – instructions related to the DDL that tells SQL Assistant what you need help with.
The default placeholder prompt that loads whenever you create a new chat with SQL Assistant, models how to create your own prompts:
The DDL statement creates a table called ‘transactions’ with 5 columns (transaction_id, customer_id, transaction_date, amount, and description).
The task description asks SQL Assistant to provide a query that will print all the transactions higher than 1000 dollars.