Write a SQL query to find the top 10 customers by recent orders.

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