使用mySQL选择至少有一个或多个订单的所有用户

Question

SELECT users.id, COUNT(?) FROM orders
INNER JOIN users ON (orders.user_id = users.id)
WHERE ??

我怎样才能输出：

UserID: 123 has made 22 orders
UserID: 124 has made 2 orders

等等？

我想只抓取有一个或多个订单的用户，并排除那些有 0 个订单的用户。

Answer 1

SELECT users.id, COUNT(*) FROM orders
INNER JOIN users ON (orders.user_id = users.id)
group by users.id
having count(*)>=1

Answer 2

SELECT users.id, COUNT(*) FROM orders
INNER JOIN users ON (orders.user_id = users.id)
GROUP BY users.id
HAVING count(*) >= 1