Dialect: Standard SQLMySQL / MariaDBPostgreSQLSQLiteMariaDBT-SQL (SQL Server) Indent: 2 spaces4 spacesTab UPPERCASE keywords

SQLcontent_copy Copy

select u.id, u.name, count(o.id) as orders from users u left join orders o on o.user_id=u.id where u.created_at > '2024-01-01' and u.status in ('active','trial') group by u.id, u.name having count(o.id) > 3 order by orders desc limit 50;

Formattedcontent_copy Copy

SELECT u.id, u.name, count(o.id) AS orders FROM users u LEFT JOIN orders o ON o.user_id = u.id WHERE u.created_at > '2024-01-01' AND u.status IN ('active', 'trial') GROUP BY u.id, u.name HAVING count(o.id) > 3 ORDER BY orders DESC LIMIT 50;