SELECT
  id,
  name,
  email
FROM
  users u
  JOIN orders o ON o.user_id = u.id
WHERE
  u.active = TRUE
  AND o.total > 100
ORDER BY
  o.total DESC
LIMIT
  10