AI SQL Query Explanation Generator

Input

{
    "goal": "Explain a SQL query joining user and order tables to analyze purchase behavior",
    "details": "The query joins users and orders on user_id, filters orders in the last 30 days, and calculates total spend per user.",
    "tone": "Professional"
}

Output

This SQL query performs an inner join between the users and orders tables using the user_id field to combine user information with their corresponding orders. It filters the dataset to include only orders placed within the last 30 days, ensuring recent purchase data. Finally, it aggregates the total spending per user by summing the order amounts, providing insights into recent customer purchase behavior.

Input

{
    "goal": "Summarize a query grouping sales data by region and product category",
    "details": "Groups sales by region and category, calculates average sales amount, excludes returns, and orders results descending by average.",
    "tone": "Casual"
}

Output

This query groups sales records by region and product category, ignoring any returned items to keep data clean. It calculates the average sales amount for each group and sorts the results so the highest average sales appear first. This helps contributors understand which regions and product categories perform best.

Input

{
    "goal": "Describe a query filtering campaign data with specific constraints",
    "details": "Filters campaigns with over 1000 impressions, calculates click-through rate (CTR), and limits output to top 5 campaigns by CTR.",
    "tone": "Persuasive"
}

Output

This SQL query targets campaigns that have generated more than 1000 impressions, ensuring only significant data is analyzed. It calculates the click-through rate by dividing clicks by impressions, providing a key performance metric. The query then selects the top 5 campaigns with the highest CTR, enabling marketing analysts to focus on the most effective campaigns quickly.