[thedevbox]
loading
SELECT users.id, users.email, count(events.id) FROM users LEFT JOIN events on events.user_id = users.id WHERE users.active = true GROUP BY users.id, users.email ORDER BY users.email;
The SQL formatter spaces and indents queries so joins, clauses, and nested statements are easier to scan during debugging, documentation, or code review.