Transform Natural Language into Perfect SQL

Find all customers who made a purchase last month

SELECT * FROM customers
WHERE purchase_date >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

Show top 5 products by revenue in Q4

SELECT product_name, SUM(revenue) as total
FROM sales WHERE quarter = 4
GROUP BY product_name ORDER BY total DESC LIMIT 5

List employees with salary above department average

SELECT e.name, e.salary, e.department
FROM employees e WHERE e.salary >
(SELECT AVG(salary) FROM employees WHERE department = e.department)