排序會員活躍度sql

我想頁面列出最活躍的會員，根據會員的文章數，評論數總和

文章                                      |                 評論                               |              

article                                    |              comment                        |             User

ID  userID                            |               ID      userID                   |                 ID

1    3                                      |               1          5                          |                   1

2    3                                      |               2          3                          |                   2

3    5                                      |               3          2                          |                   3

4    3                                      |               4          1                          |                   4

5    2                                      |               5           5                         |                   5

                                              |                6            7                        |                    7

 

    select a.id,count(distinct b.id) 'comment',count(distinct c.id) 'article' from [user] a 
    join comment b on a.id=b.userid left join article c on a.id=c.userid group by a.id 

 

輸出結果：

id   comment     article
1        1                 0
2        1                 1
3        1                 3
5        2                 1
7        1                 0

總和就是 select a.id,count(distinct b.id)+count(distinct c.id)