CC TOOLS
（by 测试蔡坨坨）
JSON
SQL
清空
1
select 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.status = 'active' and o.created_at >= '2026-01-01' group by u.id, u.name order by order_count desc;
清空
1