🚀 How To: Explain SQL

Explaining SQL in AI Query, means providing a description or interpretation of the meaning and purpose of the SQL statement in a way that is easy for non-technical users to understand. The goal of explaining SQL is to help you understand the logic behind the SQL and the data that is being returned, which can be especially useful for those who may not have a technical background in data analysis or programming. Let's take a look at how to generate an Explanation.

Steps

On the AI Query Dashboard, navigate to Explain SQL.

Below is the SQL we want to use to provide us with an Explanation:

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;

Now paste the above SQL and click ▶ to generate the explanation.

This query is used to select customer information and the number of orders they have placed. 
It starts by selecting the customer_id, first_name, and last_name from the Customers table. 
Then it joins the Orders table to the Customers table on the customer_id. 
It then groups the results by customer_id, first_name, and last_name. 
Finally, it filters the results to only include customers who have placed more than 10 orders.

You'll see that you get an Explanation generated based on the SQL you specified! 😊