DialectStandard SQLMySQLPostgreSQLSQLiteMariaDBTransact-SQLBigQueryPL/SQL

SQLselect u.id, u.name, count(o.id) as order_count from users u left join orders o on o.user_id = u.id where u.active = 1 and o.created_at > '2024-01-01' group by u.id, u.name having count(o.id) > 0 order by order_count desc limit 20;

FormatMinifyClear