🚀 How To: Generate a SQL Query

Once a database has been setup in AI Query, we are ready to start generating SQL queries. Let's take a look at how to generate SQL queries.

Steps

On the AI Query Dashboard, navigate to Query Playground and select the Database.

Select Create Query as the Query Type for the Query Prompt.

Below is a Query Prompt we want to use to generate a SQL Query:

get all customers with more than 10 orders

Now click ▶ to generate the SQL Query .

SELECT c.customer_id, c.first_name, c.last_name, COUNT(o.order_id) AS order_count
FROM Customers c
JOIN Orders o ON c.customer_id = o.customer_id
GROUP BY c.customer_id, c.first_name, c.last_name
HAVING COUNT(o.order_id) > 10;

You'll see that you get a SQL Query generated based on the Query Prompt you specified! 😁