AI SQL Query Generator

SELECT c.id, c.name, c.email, MAX(o.created_at) AS last_order
FROM customers c
LEFT JOIN orders o ON c.id = o.customer_id
GROUP BY c.id, c.name, c.email
HAVING MAX(o.created_at) < NOW() - INTERVAL '6 months'
   OR MAX(o.created_at) IS NULL
ORDER BY last_order ASC;

SELECT
  EXTRACT(MONTH FROM created_at) AS month,
  SUM(CASE WHEN EXTRACT(YEAR FROM created_at) = EXTRACT(YEAR FROM NOW())
    THEN total ELSE 0 END) AS current_year,
  SUM(CASE WHEN EXTRACT(YEAR FROM created_at) = EXTRACT(YEAR FROM NOW()) - 1
    THEN total ELSE 0 END) AS previous_year
FROM orders
WHERE created_at >= DATE_TRUNC('year', NOW()) - INTERVAL '1 year'
GROUP BY month
ORDER BY month;

SELECT email, COUNT(*) AS occurrences
FROM users
GROUP BY email
HAVING COUNT(*) > 1
ORDER BY occurrences DESC;