AI-Powered Features

-- Natural language: "Show me total sales by month"
SELECT 
  DATE_TRUNC('month', order_date) as month,
  SUM(amount) as total_sales
FROM orders 
GROUP BY month 
ORDER BY month;

-- Natural language: "Which products are most popular with premium customers?"
SELECT 
  p.name,
  COUNT(o.id) as order_count
FROM products p
JOIN order_items oi ON p.id = oi.product_id
JOIN orders o ON oi.order_id = o.id
JOIN customers c ON o.customer_id = c.id
WHERE c.tier = 'premium'
GROUP BY p.id, p.name
ORDER BY order_count DESC;

-- Natural language: "Show me daily active users for the last 30 days"
SELECT 
  DATE(created_at) as date,
  COUNT(DISTINCT user_id) as daily_active_users
FROM user_sessions
WHERE created_at >= NOW() - INTERVAL '30 days'
GROUP BY DATE(created_at)
ORDER BY date;

-- Natural language: "Compare user data from our main app and mobile app"
SELECT 
  pg_users.name,
  pg_users.email,
  mobile_users.last_login
FROM postgres_db.public.users pg_users
JOIN mysql_db.mobile.users mobile_users
  ON pg_users.email = mobile_users.email;