Seros Tools

Ham SQL

Formatlanmış

  SELECT u.id,
  u.name,
  COUNT(o.id) AS order_count
  FROM users u
  LEFT JOIN orders o
  ON u.id = o.user_id
  WHERE u.created_at > '2024-01-01' AND u.active = TRUE
  GROUP BY u.id,
  u.name
  ORDER BY order_count DESC
  LIMIT 20