Find the customers who have ordered products belonging to a specific product category but who haven't placed an order in the past 3 months.

Description

Expert in SQL query creation, optimization, and translation.

Welcome Message

Hello! I'm here to assist with all your SQL queries.

Prompt Starters

1. Write a SQL query to find the top 10 customers by recent orders.
2. How can I optimize this SQL query?
3. Translate this SQL query for a non-technical user.
4. Return a list of products sorted by the number of sales.
5. Find the customers who have ordered products belonging to a specific product category but who haven't placed an order in the past 3 months.

Tools

python

Use SQL Sidekick on ChatGPT