Your database,
understood.
Seshat is an AI-powered desktop database client. Ask in plain English, explore schemas, and run queries — privately, on your machine.
Show me customers who haven't placed an order in the last 30 days
Generated SQL
SELECT c.id, c.name, c.email,
MAX(o.created_at) AS last_order_date
FROM customers c
LEFT JOIN orders o ON c.id = o.customer_id
GROUP BY c.id, c.name, c.email
HAVING last_order_date < NOW() - INTERVAL 30 DAY
OR last_order_date IS NULL;
-- 847 rows · 43ms
MAX(o.created_at) AS last_order_date
FROM customers c
LEFT JOIN orders o ON c.id = o.customer_id
GROUP BY c.id, c.name, c.email
HAVING last_order_date < NOW() - INTERVAL 30 DAY
OR last_order_date IS NULL;
-- 847 rows · 43ms