Where humans and AI
build data products

SELECT 
  users.name, 
  orders.order_date, 
  SUM(order_items.quantity * products.price) AS total_amount
FROM 
  users
  JOIN orders ON users.id = orders.user_id
  JOIN order_items ON orders.id = order_items.order_id
  JOIN products ON order_items.product_id = products.id
WHERE 
  orders.order_date >= '2023-01-01'
GROUP BY 
  users.name, orders.order_date
ORDER BY 
  total_amount DESC
LIMIT 10;