mysql - 如何连接这两个表？

Question

我有:

TABLE: USERS
UID | NAME
1   | Bob
2   | John

我有:

TABLE: HITS
HITID | UID
1     | 1
2     | 2
3     | 2
4     | 1
5     | 2
6     | 2

我要:

UID | HITS
1   | 2
2   | 4

看起来很简单，但我好像做不到？

Answer 1

试试这个:

SELECT UID, COUNT(UID) HITS FROM HITS 
GROUP BY UID;