SQL

我想查最近 7 天内下过单的用户，SQL 该怎么写？

query

SELECT u.name, COUNT(*) AS orders
FROM users u
JOIN orders o ON o.user_id = u.id
WHERE u.created_at > '2026-01-01'
GROUP BY u.id
ORDER BY orders DESC
LIMIT 10;

sql · 图文示意