Plain English: Show me all email campaigns from Q4 2024 where open rate was above 25

SELECT campaign_name, open_rate, click_through_rate, send_date
FROM email_campaigns
WHERE send_date BETWEEN '2024-10-01' AND '2024-12-31'
  AND open_rate > 0.25
ORDER BY click_through_rate DESC;

Plain English: How many employees left voluntarily in each department in the last 6 months

SELECT department, COUNT(*) AS voluntary_departures
FROM employee_exits
WHERE exit_type = 'voluntary'
  AND exit_date >= DATEADD(month, -6, GETDATE())
GROUP BY department
ORDER BY voluntary_departures DESC;

Plain English: Accounts with lifetime revenue over $10,000 that haven't had activity in 90 days.

SELECT a.account_name, a.lifetime_revenue, MAX(act.activity_date) AS last_activity
FROM accounts a
LEFT JOIN activities act ON a.account_id = act.account_id
GROUP BY a.account_id, a.account_name, a.lifetime_revenue
HAVING a.lifetime_revenue > 10000
  AND (MAX(act.activity_date) IS NULL OR MAX(act.activity_date) < DATEADD(day, -90, GETDATE()));

Plain English: Products with stock below reorder point, not restocked in 30 days

SELECT product_id, product_name, current_stock, reorder_point
FROM inventory
WHERE current_stock < reorder_point
  AND (last_restock_date IS NULL OR last_restock_date < CURRENT_DATE - INTERVAL '30 days');