ToolHub
中文
Light
GitHub
返回首页
/
数据格式
/
SQL Formatter Plus
加载中...
格式化
压缩
关键字大写
关键字小写
载入示例
缩进宽度
2
SQL 输入
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.status = 'active' group by u.id, u.name having count(o.id) > 0 order by order_count desc limit 20
输出结果
复制
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.status = 'active' GROUP BY u.id, u.name HAVING count(o.id) > 0 ORDER BY order_count desc LIMIT 20